on 12-04-2007 7:28 PM
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.
Post Author: ROMZILBER
CA Forum: WebIntelligence Reporting
I think what BO does. and this is not what we are looking for
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Post Author: Ranjit
CA Forum: WebIntelligence Reporting
Can you sort your report by replace(FIELD, " ", "")
Ranjit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.