Sort on Running Total Results

[piazzab]

I have a client that would like to perform group sorting on the running total invoice amount placed in the Group Footer #1. Is there a way to do group sorting on a running total field? HELP!

The database is a SQL database.

 

[IdoMillet]

Can't sort on running totals.

If you explain what the running total does, there's a good chance that an alternative approach (using a regula total) could be suggested.

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[piazzab]

The line items are calculated based on the type from 2 different tables and if they are positive or negative. Then the running total calculates the total from this using a variable. Not sure if a regular total could have been done.

 

[synapsevampire]

You might try to use a Top N report (Report->Top N Sort Group Expert), set the For This Group Sort to Bottom N (or Top N if you want descending) and the Where N to be 500 or so for the invoice amount (should include all of your groups).

-k

 

[IdoMillet]

It sounds like you are creating a Conditional Count.

Here's how to create this using a simple total:

1. Create a formula that returns 1 if the condition is TRUE and 0 otherwise.

2. SUM that formula. Note: don't count -- Sum!

3. Use Report, TopN/Sort Group Expert to sort the groups
based on the Sum.

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com