Summary Total at bottom of Report 1

[kernal]

I'm using crystal 9 with a csv file:

csv file
ID Start Date
1 01/06/2004
1 03/15/2005
1 08/17/2005

2 05/10/2003
2 08/17/2005

3 03/10/2003
3 04/15/2005

4 03/10/2003

5 05/13/2003

Each start date is considered a session per ID so I have so far on group #1s footer (group is ID):

ID # of Sessions
1 3

2 2

3 2

4 1

5 1

Now I need to get a total, how many IDs had taken 1 session, 2 sessions, etc. so I need at the very bottom of the report:

# of Sessions # of IDs
1 2 (this would be ID 4 and 5)
2 2 (this would be ID 2 and 3)
3 1 (this would be ID 1)

Thanks in advance for your help.

 

[lbass]

You could insert three running totals that do a distinctcount of ID, evaluate using a formula:

distinctcount({table.startdate},{table.ID}) = 1 //or 2 or 3

Reset never.

Change the number in the evaluation formula to match the # of sessions. Place the three running totals in the report footer.

-LB

 

[kernal]

Wonderful, Wonderful! The running totals worked great. Thank you