Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Criteria on Running Totals - Reset On Change Of

Status
Not open for further replies.

nlaliberte

Programmer
Apr 26, 2007
79
US
I'm using Crystal XI. I'd like to put criteria on the 'On Change Of' in a running total. The report is run by two possible scenarios, 'run_by' 1 and 2. When 'run_by' = 1 I'd like the running total to never reset. However when it's run by 2 I'd like to reset on the change of my Group1 value.

Can someone help me out with out to do this?
 
On change of" is used in both the evaluation and reset areas, but if you only are referring to the reset, I think you can use a formula in the reset section like this:

(
{table.runby} = 2 and
{table.group#1field} <> previous({table.group#1field})
)

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top