Crystal Reports

How can you sort by a formula in Crystal Reports 10?
vbjohnAsked:
Who is Participating?
 
mlmccCommented:
I don't think you can since SUM is inherently a PRINT TIME function.

mlmcc
0
 
mlmccCommented:
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
0
 
vbjohnAuthor Commented:
IF Sum({@TotalSaleDollars})<>0 THEN
    {HistoryType.PTTotalSale}%Sum ({@TotalSaleDollars})
Else
    0
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
vbjohnAuthor Commented:
Ahhh Rats.
0
 
vbjohnAuthor Commented:
thanks for your help.  I gave you the points for helping me out.
0
 
mlmccCommented:
Glad i could help

mlmcc
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.