running total question using crystal 10.0 1

[espltd]

Hi, I have the following data and would like to set up a count as follows. The data in the details section of the report is the first 3 columns and I would like to add the fourth column called count.

user start time end time count

A 10:00 11:00 1
A 10:00 11:00 2
A 10:00 11:30 1 (reset count)
B 1:00 2:00 1 (reset count)
B 1:00 2:00 2


so it counts when there is the same user and start and stop times.

I also have a crosstab set up and would like to display

A 2
B 2
so it only displays the user and the max count. Thanks.

 

[lbass]

I was referring to using the formula instead of a running total in the crosstab, but you can use it in the main report, too. Just place it in the detail section and insert summaries on it at any group level.

-LB

 

[espltd]

thanks for the additional information. I think I finally have this working correctly, ended up sorting the data a bit differently and using a modification of the provided formula in the details section and then inserting summaries at various group levels as suggested.