I have a report with several groups with SUM fomulas in each one. I am trying to do a count of all the records that are showing in the report and adding it in the group footer. I have the numbers converted to strings but I keep getting errors.

Doing a running total only gives you the option of adding one group. I need the total of all records from all groups.

I tried doing them in the detail section but I could not get the other calculations to come out right and if the field did not have anything in it, it would leave a blank line in the report even if I told it to suppress blank.

It is in a payroll system and I have them grouped by their paycode. and then I do a running total and set it to evaluate for each record and reset on change of name. The sums are in the group footers for each. I technically only have one group the others are just sections of that group. like group 1a,1b and so on.

Edited by KevV - 23 Jul 2013 at 12:16pm

I do a sum on the others so it adds up all the hours. What I need is a count of how many actuall records I have. So it may be 10 hours of time but it is only one record. If I just set it to never reset it just adds all the hours. I have tried doing a count but that did not work either.