Creating a running total and breaking at a certain change

[cvasquez]

Hello everyone.

I have created a report that breaks currently on state field,{SYSCUST.STATE} by having a group header.
Now I am being asked to have a running total to also break on state field. The running totals field data information is coming from {SYSCUST.YTD_PURCH}.

Please help thanks.

 

[lbass]

Just set the reset part of the running total to "on change of group" and choose the state group. Then place the running total in the group footer.

-LB

 

[cvasquez]

Easier said than done.
I am new to Crystal 10. How do I set up the running totals?

I believe I have to set up a counting field to keep adding the totals field, {SYSCUST.YTD_PURCH}.

 

[lbass]

Go to the field explorer->insert a running total. Select your field, sum, evaluate for each record, reset on change of group.

-LB

 

[cvasquez]

Awzome. Thanks.