Community
Participate
Working Groups
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
Created attachment 194781 [details] Simple report design showing crosstab sorting defect
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.
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.
