Link to home
Start Free TrialLog in
Avatar of ldhon
ldhon

asked on

Crystal Report Sort Formula

I have a Crystal Report formula for a parameter I enter.  The first two work great, number three is not sorting how I want it.

It is sorting it like below:

0
1
2
3
4

I would like it sorted like:

20
19
18
17
16

The formula is below:

if {?SortColumns} = '1' then {Command.findname} else
if {?SortColumns} = '2' then {Command.lendercode} else
if {?SortColumns} = '3' then totext({Command.age},"00",0)

I want option number three to sort descending.  What in the world am I doing wrong?

Thank you in advance.
ASKER CERTIFIED SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of ldhon
ldhon

ASKER

Thank you very much mimcc.  Your solution is greatly appreciated.