 |
|||||
|
As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Join the TIBCO Community
Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community. | |||||
Focal Point 
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED]Bursting with mixed case sort values
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED]Bursting with mixed case sort values Read-Only TopicGo | Search | Notify | Tools |
| [SOLVED]Bursting with mixed case sort values | Login/Join |
| Gold member |
We are experiencing some issues with bursting compound PDF reports. If the primary sort field value for which we are bursting contain mixed case letters, we are either getting Adobe errors or data mixup among reports. It doesn't happen for all sort values with mixed case which makes it hard to debug. But, if we convert sort values to uppercase, it seems to fix the problem. Has anyone experienced this problem before? We are trying to avoid converting the sort values to uppercase if possible because we use it for display purpose also and there are 100+ reports that gets affected by this change. Thanks for the help.This message has been edited. Last edited by: CT, 7.6.9, XP | ||
|
| Guru |
This could be caused by the fact that in the ASCII collating sequence upper case and lower case letters are not in sequence, Therefor Aa dose not follow or precede AA but comes after AZ. WF 7.6.11 Oracle WebSphere Windows NT-5.2 x86 32bit | |||
|
| Gold member |
Thanks. It makes sense. Is there a setting in WebFocus reporting server or somewhere to ignore the case when sorting? Thanks for the help. 7.6.9, XP | |||
|
| Virtuoso |
Two approaches to try: #1. use TABLE ... BY myUpperCaseValue NOPRINT BY mixedCaseValue -- where myUpperCaseValue is either predefined in the data source table, or DEFINEd using UPCASE() function #2. perhaps you can hold in desired order (using #1), and then TABLEF ... BY mixedCaseValue - TABLEF will break whenever the sort-key value changes, regardless of direction of the change -- but I'm not sure that Reportcaster bursting will work with TABLEF. | |||
|
| Gold member |
Thanks j.gross and RSquared. Your responses gave me some clues on what to look for. We are able to find a setting which solved our problem. COLLATION = enabling keyword Internal default: CODEPAGE Establish Binary or Case-Insensitive Collation Sequence. The keyword values are: CODEPAGE Bases collation sequence on the code page in effect BINARY Bases the collation sequence on binary values SRV_CS Bases collation sequence on the LANGUAGE setting, and is case-sensitive SRV_CI Bases collation sequence on the LANGUAGE setting, and is case-insensitive We changed this setting from SRV_CI to SRV_CS which fixed our problem I think when report castor bursts reports, they are in ASCII collating sequence, so the setting SRV_Cl made them out of order with the BY field values in the report. 7.6.9, XP | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicFocal Point Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED]Bursting with mixed case sort values
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED]Bursting with mixed case sort valuesCopyright © 1996-2020 Information Builders
| View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |