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

SAP Knowledge Base Article - Public

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

Symptom

  • 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

Environment

Crystal Reports 2008 Service Pack 2

Reproducing the Issue

This is an Example with Excel file:

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

     

ENAME

Dept_No

Tenure

µ

1

2mon

AD

2

5mon

JF

3

10mon

MT

4

1year

KF

5

2year

SI

6

5year

OM

7

2year

PQ

8

1year

RW

9

5mon

10

1 year

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):

ENAME

Dept_No

Tenure

µ

1

2mon

AD

2

5mon

JF

3

10mon

MT

4

1year

KF

5

2year

SI

6

5year

OM

7

2year

PQ

8

1year

RW

9

5mon

10

1 year

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:

µ

1

2mon

AD

2

5mon

JF

3

10mon

MT

4

1year

KF

5

2year

10

1 year

     
     
     

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.

Cause

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

Resolution

An Enhancement Request has been created under reference number ADAPT01383967.
The Enhancement Request (ER) will be considered in terms of future product development when considering possible new features in the next major release. Please note that the ER may or may not be included depending on various factors.

Keywords

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

Product

Crystal Reports 2008 V1