CR8.0 - Is there a way to Sort Records based on a Summarized Formula?

[PaulinKC]

Ok, I've got 3 formula fields, the first two just displays the field data for a particular field in the database. The 3rd field subtracts the first two and just returns a value.

EX:

FormulaTransactType = 3111
Total For 3111 = 2000.00

FormulaTransactType = 3112
Total For 3112 = 6000.00


FormulaTotal = (Sum(FormulaTransactType3112) - Sum(FormulaTransacType3111))

The FormulaTotal is summarized with a grand total being displayed at the time. Is there a way to Sort the FormulaTotal so that the greatest amount is being displayed first? Let me know as soon as possible.

Thanks,

Paul Friedrichsmeyer
Infini-Source - One Source Solutions

http://www.infini-source.com

paulf@infini-source.com

 

[rhinok]

Navigate to the following menu: Report|Top N/Sort Group Expert. In your scenario, the options you'd select are:

For this group sort: All
Based on: Sum of {your summarized formula field}
Order: Descending

Hope this helps!

 

[PaulinKC]

Thanks for the info, but that did not work for this report.

 

[dgillz]

Create a new formula and put it in your detail section:
@FormulaTransactType3112-@FormulaTransacType3111

You can delete or suppress this formula later if you do not want it to appear on your report. Then right click on it and select insert summary. Then follow rhinok's instructions on TopN reporting.



Software Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com