Skip to Content

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

Sorting numbers in Crystal Reports 10

I have a field that was originally in a string format, but I converted it to a number.

I have values ranging from 7000 to 10000.

I want to sort in either ascending or descending order it doesn't matter.

The results I get are not what I want. It either sorts it one of the following orders.

10000

7000

8000

9000

or

9000

8000

7000

10000

I want it to do the following:

7000

8000

9000

10000

or

10000

9000

8000

7000

Any ideas how to make it sort it correctly?

replied

Christian,

It appears to be sorting a string field still, try creating a formula that converts the string to a number using the tonumber function and sort on the formula.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question