OraFAQ Forum: Reports & Discoverer » order by in 5 queries report

Home » Developer & Programmer » Reports & Discoverer » order by in 5 queries report

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

order by in 5 queries report [message #253839]

Wed, 25 July 2007 01:14

rzkhan
Messages: 370
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 1186 times)

Report message to a moderator

Re: order by in 5 queries report [message #253848 is a reply to message #253839]

Wed, 25 July 2007 02:00

Littlefoot
Messages: 21821
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.

Report message to a moderator

Re: order by in 5 queries report [message #253864 is a reply to message #253839]

Wed, 25 July 2007 02:36

rzkhan
Messages: 370
Registered: March 2005

Senior Member

I want to order by the red circle item. (location)

Attachment: bill20.JPG
(Size: 97.51KB, Downloaded 735 times)

Report message to a moderator

Re: order by in 5 queries report [message #253886 is a reply to message #253864]

Wed, 25 July 2007 04:00

Littlefoot
Messages: 21821
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, ...

Report message to a moderator

Re: order by in 5 queries report [message #253890 is a reply to message #253886]

Wed, 25 July 2007 04:20

rzkhan
Messages: 370
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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 08 08:37:47 CST 2024