Link to home
Start Free TrialLog in
Avatar of vbjohn
vbjohn

asked on

Crystal Reports

How can you sort by a formula in Crystal Reports 10?
Avatar of Mike McCracken
Mike McCracken

It depends on the formula.  

In CR8
Open the report
Click REPORT --> SORT Expert
Select the formula

If it is a printtime formula you cannot sort by it.

What is the formula?

mlmcc
Avatar of vbjohn

ASKER

IF Sum({@TotalSaleDollars})<>0 THEN
    {HistoryType.PTTotalSale}%Sum ({@TotalSaleDollars})
Else
    0
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 vbjohn

ASKER

Ahhh Rats.
Avatar of vbjohn

ASKER

thanks for your help.  I gave you the points for helping me out.
Glad i could help

mlmcc