Home » Developer & Programmer » Reports & Discoverer » Problem sorting alphabetical caracters with numbers
Problem sorting alphabetical caracters with numbers [message #242311] Fri, 01 June 2007 09:57
rrd@ctisoft.es
Messages: 1
Registered: June 2007
Junior Member
Hi, I'm new on Discoverer and I've problem sorting a column. I've a table called TB_Products and I´m calling Code and Description columns from this table. After that I´ve sorted my report by Code ascending, but I´ve a problem with codes containing alphabetical caracters and numbers, and I think it must be sorted this way:

Description

description 1st
description 2nd
description 3th

Code
1234 TH200HH
1234 THADDHH
1234 THBDDHH


but Discoverer order them this way:

Description
description 2nd
description 3th
description 1st

Code
1234 THADDHH
1234 THBDDHH
1234 TH200HH

If I copy Discoverer's sql and run it directly against my date base it sort them correctly (like in first example). Could anybody help me, please?

Regards, Ramon
Previous Topic: Oracle Discoverer 3.1 errorr - ORA-03123
Next Topic: Escaping in discoverer
Goto Forum:
  


Current Time: Sat Dec 03 17:53:55 CST 2016

Total time taken to generate the page: 0.05493 seconds