cancel
Showing results for 
Search instead for 
Did you mean: 

SORT order in BO vs Database that is attached to

Former Member
0 Kudos

Post Author: ROMZILBER

CA Forum: WebIntelligence Reporting

Hello

We have another issue with WEBi reports. When we do sor

Database sorts values this way:

u201CA Cu201D

u201CA Mu201D

u201CAE

u201CAIu201D

Why Business Object does not consider space as a valid character for sorting. So it will sort the same values different way

u201CA Cu201D

u201CAEu201D

u201CAIu201D

u201CA Mu201D

I would appreciate any help on this and the previous issues.

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

Post Author: ROMZILBER

CA Forum: WebIntelligence Reporting

I think what BO does. and this is not what we are looking for

Former Member
0 Kudos

Post Author: Ranjit

CA Forum: WebIntelligence Reporting

Can you sort your report by replace(FIELD, " ", "")

Ranjit

Former Member
0 Kudos

Post Author: ROMZILBER

CA Forum: WebIntelligence Reporting

Hello

When I just run Oracle query it sorts them correctly, so I do not think this is a data issue. We have talk to BO and they said "

Hi Tim, the behavior you experienced in sorting with space is currently by design. To define the sort you want to accomplish, webi allows you to create a custom sort." but it is kind of pain to do it for every report. I wish you can just change it globally. Does any know of any work around?

Former Member
0 Kudos

Post Author: jsanzone

CA Forum: WebIntelligence Reporting

Are you absolutely sure that there is a space within your data and not some other non-printable character masquerading around as a space? The only way to tell for sure is to use a low-level program that can examine each position within your data and give you the ASCII code for it. For instance ASCII 65 represents "A" and ASCII 32 represents a single space. Chances are something is up with your data that is causing you to question the collating that is taking place...