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

I am using AS 10g 10.1.2.0.0 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 10.1.2.0.2?

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


Current Time: Sun Dec 11 06:22:21 CST 2016

Total time taken to generate the page: 0.07858 seconds