Home » Developer & Programmer » Reports & Discoverer » order by in 5 queries report
order by in 5 queries report [message #253839] Wed, 25 July 2007 01:14 Go to next message
rzkhan
Messages: 345
Registered: March 2005
Senior Member
hi..
I have a report (attached) based on 5 queries. How can I set the order by clause of the report.

I have set it in query 1 but it has no effect. Please guide me any one..

report attached.

Thank you,
Riaz
  • Attachment: bill20.RDF
    (Size: 80.00KB, Downloaded 179 times)
Re: order by in 5 queries report [message #253848 is a reply to message #253839] Wed, 25 July 2007 02:00 Go to previous messageGo to next message
Littlefoot
Messages: 20897
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Currently, you are ordering records by
order by bill.member_id, 
         decode(items.item, 'MESSING', CHR(0), items.item)
As 'bill.member_id' is a CHARACTER item (not a NUMBER), does this fact leads you to conclusion that Reports Builder does not sort records properly? Because, in that case you'd get (for example)
what you have   what you want
-------------   -------------
A1              A1
A11             A2
A2              A4
A30             A11
A4              A30
If this is not the case, what is it, then? You didn't provide any input data or example of the output so all we can do is to guess blindly.
Re: order by in 5 queries report [message #253864 is a reply to message #253839] Wed, 25 July 2007 02:36 Go to previous messageGo to next message
rzkhan
Messages: 345
Registered: March 2005
Senior Member
I want to order by the red circle item. (location)
  • Attachment: bill20.JPG
    (Size: 97.51KB, Downloaded 147 times)
Re: order by in 5 queries report [message #253886 is a reply to message #253864] Wed, 25 July 2007 04:00 Go to previous messageGo to next message
Littlefoot
Messages: 20897
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
In that case, you'll have to move the LOCATION column into the Q_1 query and order by location first, i.e.
order by location, member_id, ...
Re: order by in 5 queries report [message #253890 is a reply to message #253886] Wed, 25 July 2007 04:20 Go to previous message
rzkhan
Messages: 345
Registered: March 2005
Senior Member
In addition to Q_1, I also added location to Q_4 and applied your order by clause.

It works fine now...

Bundle of Thanks

Riaz
Previous Topic: Reports Performance
Next Topic: PROBLEM---Drill Down Report On web
Goto Forum:
  


Current Time: Wed Dec 07 03:07:08 CST 2016

Total time taken to generate the page: 0.13605 seconds