SAP Knowledge Base Article - Public

1843282 - Case sensitive sort issue - ASCII compared to Alphabetical values

Symptom

The expected sort is - special characters,  0-9, A-Z, a-z. ASCII sort dependent on the values of the characters

Environment

Crystal Reports

Reproducing the Issue

Sorting a row of data returns these results:

Pre-Sort Order

Ascending Order

Case-Sensitive Order

c

A

A

D

a

B

a

B

C

d

b

D

B

C

a

C

c

b

A

D

c

b

d

d

Cause

Crystal Reports Design and related products are built using Microsoft's C++ compiler and related API set.

Sorting is based on the Alphabet an not on the ASCII values.

Keywords

KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

Product

Crystal Reports 2008 V0