Count of field occurences

[DerbyNeal]

Hi,

I am trying to get a 'Count' of field occurrences at group 2 level - but at present it is always being reset to '1'. How do I 'Count' the field occurences at group 2 level?

For example if:

Group 1 = Employee's Name
Group 2 = Duties performed
Group 3 = Time taken
AND....
Joe Bloggs performed Job123, Job456 which took 30 mins & 30 mins respectively
Jane Bloggs performed Job444 which took 60 mins
Joanne Bloggs performed Job123, Job789, Job222 which took 30 mins, 15 mins & 15 mins respectively

It should be output as:
Joe Bloggs
1
30 mins
2
30 mins
Jane Bloggs
1
60 mins
Joanne Bloggs
1
30 mins
2
15 mins
3
15 mins

Any ideas please?

 

[lbass]

If you want to show the count as it accumulates, then insert a running total that does a distinctcount of job, evaluate for each record, reset on change of group (employee). Place it in a detail_a section, if you want the exact display as above, with your time in detail_b.

Otherwise, you can simply insert a distinctcount on job at the job group level (assuming "duties performed" = job.

-LB