help with running total

[chrome9]

I'm new to Crystal Reports and can't seem to get my report to sort the records by running totals. I can sort by name, employee id, quantity, price, and everything else except running total. Why is this? and what can I do?

 

[MJSQA]

Can you give a better idea of what you are doing. What do you mean by sorting by running totals. Is this a field in the table, a formula, ...? Have you tried doing a topN sort or anything like that>

 

[chelseatech]

There is a lovely diagram of all the processes that happen during the processing of a Crystal report - p 660 of the CR8.5 manual, and well towards the back of the earlier manuals.

It is mainly to explain when to WhileReadingRecords and WhilePrintingRecords, but can also explain why you can't do summaries of summaries, or sort by running totals.

Running Totals are calculated late into the processing cycle - after the records have been sorted. Can you use a sumamry field instead and then a TopN or SortN on that summary? Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm