How to create parameter on results of running totals?

[Cores]

Hi,
CRXI SQL Server

We have an accounting report that has columns with running totals for fields - {#run_approved},{#run_paid}, {#run_cancelled},{#run_refund}.

The last right column has formula @run_balance:
{#run_approved} -{#run_paid}-{#run_cancelled} +{#run_refund}.

The results of @run_balance can be 0 or more than 0.
The client wants to create parameter on balance results - to select for ex. the rows with balances > 0.

Please point me in a right direction how to do this?

Thanks very much

 

[Madawc]

Running totals are among the last things to be calculated by Crystal, whereas parameters come first. Is there a reason you can't use Summary Totals?

(If you're not already familiar with Crystal's automated totals, see FAQ767-6524.)

Even with summary totals, you can't control the selection, unless you use a subreport in the report footer. (That would also work with Running Totals, I think.)

Are you familiar with Crosstabs? Maybe they could give you the output you want.

Madawc Williams (East Anglia, UK). Using Crystal 10 & 11.5 with Windows XP

 

[lbass]

About all you would be able to do is conditionally suppress the running totals using a parameter, e.g.,

{@yourrunningtotalcalc} < {?Parm}

-LB

 

[Cores]

Thanks Madawc and lbass for your suggestions.

Sorry for late response - I was on vacation.