Good afternoon all!! Im hoping you can help me

Im creating a report within CR XI to create a drill down of work carried out by a member of staff. Ive done this so far by creating 3 groups (for the location, date and room/staff member) and everythings running well. The issue we have is that we have some new members of staff that have come on board, and as such theyve been teaming up as a "Panel" so they can learn on the job.

The issue with this so far is that it only shows me one member of staff for each days work. Heres an example-

If Mr adam completes a full days work, he would clear 6 points. However if theres a list of 12 points, its more than likely there were two people in that room but its only coming up with one persons name. I need to know that there was another person in that room doing the work with him so i can account for it.

I remember coming to this forum for a similar query in the past and someone recommended i make 3 formula's with the following info:-

[Formula1]- Whileprintingrecords;
Stringvar flag:=" ";


[Formula2]- Whileprintingrecords;
Stringvar flag:= flag + (if instr(Stringvar flag,{Category.Flag}) > 0 then "" else {Category.Flag} + ' ')

[Formula3]- Whileprintingrecords;
Stringvar flag;



I was told i needed to put Formula 1 and 3 in supressed groups to account for the calculations. This was useful when i was picking a series of flags up against entries. The issue i have this time around is that i dont want to make any more groups up in fear my report gets messier than it needs to be, and wanted to know if there was another way around this.

Could someone help me find the best way around this? Im sorry if ive not been great at explaining

many thanks in advance.

Hi There and thanks for your reply.

Sorry for the lack of information, you're right ive put the name as a field in the Group 3 header. Essentially i could do with knowing the names of the people in that group so i can account for it. Is there any way to do this?

kind regards