Home » Developer & Programmer » Reports & Discoverer » Alternate Sort and range queries
Alternate Sort and range queries [message #186242] Mon, 07 August 2006 02:50
Messages: 14
Registered: May 2006
Junior Member

I am using AS 10g and Discover of the same version. I need to order the items in one column in a different way than what Discoverer is producing by comparing the items using their ASCII representation.

I created an alternate sort using another item where the ranking of each item is defined in my desired order ('A' -> 5, 'B' -> 3, etc).

When I create a report, I can sort the column using my defined alternate sort. However, when I try to specify a condition in the form:
'column_name' > :parameter
it seems that Discoverer reverts to using ASCII comparisons to evaluate this inequality, thus producing wrong results. Has anyone encountered this? Can I do something to correct this? If this is a bug, does anyone know if it has been fixed in

Thank you,
Previous Topic: Discoverer report doesn't fetch any data when i change responsibility
Next Topic: Delimiteddata format
Goto Forum:

Current Time: Sun Aug 20 19:57:48 CDT 2017

Total time taken to generate the page: 0.06178 seconds