order by in 5 queries report [message #253839] |
Wed, 25 July 2007 01:14 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 1156 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 message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
Currently, you are ordering records byorder 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.
|
|
|
|
|
|