OraFAQ Forum: Reports & Discoverer » Problem sorting alphabetical caracters with numbers

Home » Developer & Programmer » Reports & Discoverer » Problem sorting alphabetical caracters with numbers

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

Previous Topic:	Oracle Discoverer 3.1 errorr - ORA-03123
Next Topic:	Escaping in discoverer

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jul 04 12:02:09 CDT 2024