Counting Issue 1

[Pete271]

I am using Crystal Reports 8.5 and an Access database.

I am trying to write a report counting how many meetings members of staff have had, split by the type of meetings.

I wanted to group by staff member and then do running totals for each meeting type.

The formula @Name to group by was
if "Smith, John" in {Staff.TABLE} then "John Smith"

The Running Total
Summarise - MeetingStatus
Evaluate - Formula - MeetingStatus = "Ask" //this changes for each different MeetingStatus
Reset - On change of group @Name

The problem I have encountered is that if more than one staff member attends the meeting neither staff member is being counted. The entry in {Staff.TABLE} will be

"Smith, John; Jones, David"

Is there a way for me to count the staff members in these cases?

Regards
Peter

 

[lbass]

How many staff people are there? You might be better off grouping based on meeting status and then doing an individual running total per staff person at the meeting type group level, where you use an evaluation formula like this:

"Smith, John" in {table.staff}

-LB

 

[Pete271]

Works perfectly, thank you.