Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

sort running total

Status
Not open for further replies.

jjenright

Technical User
May 23, 2006
14
US
I am using crystal xi. How can I sort on a running total field ? Is it possible ? I want to show the top 10 spending amounts for a group of vendors.

Thank You for your assistance.
 
You can't sort on a running total, because Crystal handles sorting before it calculates the running totals. A summary total would allow it, see FAQ767-6524 if you're not already familiar with them.

You might be able to do something using TopN.

[yinyang] Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10 [yinyang]
 
Can you explain why you are using running totals? How is the running total set up?

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top