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.
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",
I want option number three to sort descending. What in the world am I doing wrong?
Thank you in advance.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER