Sorting issue when special charcter is there in the text value

[balacs11]

I am facing an issue with sorting the data when special character is there in the text value

My data looks like the below ,
Column name : Data
1.Value Sort 1
2.ValueSort1
3.Value!Sort1
4.Value#Sort1
5.Value_Sort1

I have sorting field "Data" set to Ascending

It sorts like the below,

1.Value_Sort1
2.Value!Sort1
3.Value#Sort1
4.ValueSort1
5.Value Sort 1

The encoding is UTF-8. 

Expected output:

1.Value Sort 1
2.Value!Sort1
3.Value#Sort1
4.Value_Sort1
5.ValueSort1

Any idea why it is happening like this?
 

[hozawa]

You haven't provided steps to reproduce so I'm not certain but it may be that the jdbc driver needs encoding argument.

[Friendly User]

Sort Field uses default Java comparator to sort the fields. I don't think it's possible to implement a custom comparator for the Sort Field feature. This sounds like an enhancement reuqest territory

[hozawa]

If you're using a database, it's better to use 'ORDER BY' clause in the sql statement instead of using JasperReports' sort feature because sort feature uses in-memory sorting.

Following interface explains about JasperReports sort feature.

http://jasperreports.sourceforge.net/api/net/sf/jasperreports/engine/JRSortField.html

[balacs11]

Thanks for the valueable inputs. 

I have tried these and finally ended up accepting the default behavior of Jaspersoft sorting.

1)Changing the encoding in server level - but didnt work

2)Moving the sort order to query - it works but my report requirement (Crystal report vs Jasper comparison )

In addition , It is a comparison between Crystal and Jasper reports. These two never gets same sort order even if the sorting is moved to query.