I have a summary report where I select records with a value of "assigned" in a field. I group on Assigned Group. This works well. Brings back 343 records, totals them by Assigned Group. What I need to do is do a Count of all records that have this "Assigned" value for less than 24 hours. Thanks to Naith for this calc - DateDiff('h',{HD_Ticket.Create-date},CurrentDate) < 24 (Produces Boolean)
I don't want this as part of my record selection but want it as part of my summary (Count) field in my Group footer along with a few other counts. For instance, out of 343 records, HD Staff has 30 with a value of Assigned. Of those 30, 24 have been opened in the last 24 hours and 5 greater than 24 hours. I need to have the group footer display:
HD Staff 30 24 x x x
where 30 is the sum count of all records, 24 the sum count of all records that have been opened in the last 24 hours, etc.
Dave
I don't want this as part of my record selection but want it as part of my summary (Count) field in my Group footer along with a few other counts. For instance, out of 343 records, HD Staff has 30 with a value of Assigned. Of those 30, 24 have been opened in the last 24 hours and 5 greater than 24 hours. I need to have the group footer display:
HD Staff 30 24 x x x
where 30 is the sum count of all records, 24 the sum count of all records that have been opened in the last 24 hours, etc.
Dave