Sort based on two formulas

[bpunc]

I have the following:
FormulaA - numeric field
FormulaB - numeric field

I take the subtotals of FormulaA and FormulaB and divide it (i.e., A/B) to create FormulaC.

Now, I want to sort FormulaC (based on subtotals) but I can't. The "Sum of FormulaC" is not listed in the TopN/Sort Group Expert.

Is there an alternative to do this?
Thanks in advance!

 

[kenhamady]

You can only TopN on Summaries and you can't summarize formula C because it is based on Sums. I don't see how you can do this in CR. Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/

 

[chelseatech]

Ken is correct. It has to be a summary or subtotal to be a TopN.

Is a TopN of Formual A going to give you the corect sequence. I suspect not.

The only solution I can see is to do your summary in the database via a View or Stored proc and then use that as the source to your report.

http://www.chelseatech.co.nz

Editor of Crystal Clear