Home » Developer & Programmer » Reports & Discoverer » order by in 5 queries report
|
Re: order by in 5 queries report [message #253848 is a reply to message #253839] |
Wed, 25 July 2007 02:00   |
 |
Littlefoot
Messages: 21823 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.
|
|
|
|
|
|
Goto Forum:
Current Time: Thu May 01 09:43:21 CDT 2025
|