Joined: 19 May 2011
Online Status: Offline
Posts: 106
Topic: Counting number of records Posted: 23 Jul 2013 at 11:15am
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.
Joined: 19 May 2011
Online Status: Offline
Posts: 106
Posted: 23 Jul 2013 at 11:57am
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.
Joined: 19 May 2011
Online Status: Offline
Posts: 106
Posted: 23 Jul 2013 at 12:10pm
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.
Joined: 19 May 2011
Online Status: Offline
Posts: 106
Posted: 24 Jul 2013 at 6:00am
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.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum