Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 344775

Summary: Sorting crosstab by primary strength not working
Product: z_Archived Reporter: Aaron Getz <getza1>
Component: BIRTAssignee: Birt-Data-inbox <Birt-Data-inbox>
Status: NEW --- QA Contact: Xiaoying Gu <bluesoldier>
Severity: normal    
Priority: P3 CC: bluesoldier
Version: 2.6.1   
Target Milestone: ---   
Hardware: PC   
OS: Linux   
Whiteboard:
Attachments:
Description Flags
CSV datasource file for report design
none
Simple report design showing crosstab sorting defect
none
CSV data source with unicode example none

Description Aaron Getz CLA 2011-05-04 19:07:39 EDT
Created attachment 194780 [details]
CSV datasource file for report design

When trying to sort a crosstab using primary strength it does not work.  I have created a simple report design which show this defect.  It uses a CSV data source named
Comment 1 Aaron Getz CLA 2011-05-04 19:09:03 EDT
Created attachment 194781 [details]
Simple report design showing crosstab sorting defect
Comment 2 Aaron Getz CLA 2011-05-04 19:13:28 EDT
Sorry for this messed up defect submission.  So when sorting a crosstab by primary strength it still sorts by ascii.  

The attached report design shows that sorting the names contained in the data source will sort by ascii in the crosstab but will sort correctly in the table.

I have only tried the primary sort strength so not sure about the other ones.

We were using BIRT 2.5.2 and everything was sorting correctly and then when we switched to BIRT 2.6.1 we started having sorting issues where everything was being sorted ascii.  Is there a way to have it go back to sorting like it did in 2.5.2?  Right now we are having to go through a bunch of reports and set the sorting to primary, and that is how we came across the issue in the crosstab.
Comment 3 Jan Inowolski CLA 2013-03-07 09:14:27 EST
Created attachment 228067 [details]
CSV data source with unicode example

Bug is present in 3.7.

It affects also sorting of unicode characters with accents, because of applying ASCII sorting strength instead of primary. It is important for us that data like people last names are sorted correctly in a cross tab.