Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to - Grouping (and sorting the groups) in Swedish Alphabetical Order?

Hello experts!

currently I have CR Group By results ordered as follows:

a

å

ä

b

c

-

-

z


I need:

a

b

c

-

-

z

å

ä

ö

I am wondering if there is any way I can create a group (based on a text field) that possibly contains special swedish characters such as Å, Ä, and Ö. AND have the grouping sequence respect that Swedish special characters appear after Z, based on the order in Swedish alphabet. If it was only a sorting issue, I think I could get away with changing the SQL collation setting (set on the actual SQLServer Database) and check the "perform sort on server-side" checkbox in crystal reports options.


But, because the group involves some formulas, this forces the grouping to happen on the Client-Side (within crystal reports), and so, the "natural" sorting order is the generic sort order where Ä appears after A and  Ö appears after O.... instead of having both appear after Z.

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question