Running Total 1

[xanra]

Hi, i'm trying to display the final value for a running total.

I have credit card charges by date and card type that i'm pulling from a database.

I'm able to display a running total for each row where it resets if either the day/card type changes. However it is mind numbing to look at.

Is there a way to only display the final value of a running total and then have it reset to blank until there is another change?

For example it is displaying the following
10/1 VISA $50 $50
10/1 VISA $50 $100
10/1 VISA $30 $130
10/2 VISA $50 $50
10/2 VISA $30 $80
10/2 DISC $50 $50


Instead is there a way to make it display :
10/1 VISA $50
10/1 VISA $50
10/1 VISA $30 $130
10/2 VISA $50
10/2 VIS $30 $80
10/2 DISC $50 $50

I'm using CR 11 .

Thanks in advance!
-Paul

 

[lbass]

Create a formula:

if onlastrecord or
{table.date} <> next({table.date}) or
{table.card} <> next({table.card}) then
{#yourrt}

Use this formula instead of the running total on the report and then right click on it->format field->number->customize->suppress if zero.

-LB

 

[xanra]

thank you very much!!