Running total display

[lissa1974]

Hi there, I have a problem in displaying a running total and wondered if there was any way around it. Using CR8.5 and SQL server.

Basically, I have a header with totals based on the sums and counts of the groups below, so quite easy set up. One of the columns I need to use a running total for, which when I put the total in the footer it's fine, but obviously when I slap it into the header it doesn't work.

so, is there any way I can leave the total in the footer, supress it, and then have a formula in the header just "Printing" the value into a text box??

Any help is welcome, thanks

 

[lbass]

No. Please explain the exact setup of the running total.

-LB

 

[Madawc]

The point about a running total is that it 'runs' along with the printing. So it will be zero in the header and have its full value in the footer. You can also use it for details - identity the third record, say.

If you're using a running total because it is conditional, you can get the same effect using a summary on a detail-line formula field. Something like

If {cond} = "A" then {amount} else 0

The use of Crystal totals is outlined at FAQ767-6524.

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