1447291 - Using Sort function dispalys wrong order in Crystal reports when data contains special characters

• Incorrect results while adding 'is between' in a record selection formula for special characters in Crystal
• Crystal Displays uneven order of data while using 'is between' function based on special characters

Crystal Reports 2008 Service Pack 2

This is an Example with Excel file:

1) Create a excel file 'Special Character'with below details:

2) Launch Crystal and create a blank report with new connection Access/Excel [DAO] > Database name (Select the excel file) > Database type as Excel 8.0

3) Click on Finish.

4) Select the Sheet1$ in the tables section, click Ok

5) In the Design view, place all the 3 filed in detail section Preview the report (below output is returned):

6) Click On Report Tab on the Crystal Menu>Select Expert>Record

7) In the choose filed box select field ENAME, Click Ok

8) In Select Expert>ENAME>is between>select 'µ' and 'KF' and this shows the formula as {Sheet1_.ENAME} in 'µ' to 'KF' , Click OK

9) Choose Refresh data option for Change in record selection formula window

10) Following result is displayed:

NOTE: This could also happen with the below formulas: 

- {Sheet_.ENAME} in 'SI' to '€': as a record selection formula this should display only 3 results however it displays incorrect order of data according to the order in the excel sheet.

This seems to be the default behavior in Crystal Reports 2008.

Crystal Sort, Special Character sort , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Product Enhancement