Counting Groups in a report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report with the following grouping levels

Driver
Dat
DropOffTim

I can get a count of the number of records that appeared in the group Date, but I need to know how to count the number of time the Date group appeared in the report. Any info is appreciated. Thanks.
 
You can add a field to your date group, with a value of 1,
make it invisible, and have a count of this field in your
report footing.

-----Original Message-----
I have a report with the following grouping levels:

Driver#
Date
DropOffTime

I can get a count of the number of records that appeared
Click to expand...
in the group Date, but I need to know how to count the
number of time the Date group appeared in the report. Any
info is appreciated. Thanks.
 
Tom said:
I have a report with the following grouping levels:

Driver#
Date
DropOffTime

I can get a count of the number of records that appeared in the group Date, but I need to know how to count the number of time the Date group appeared in the report. Any info is appreciated. Thanks.
Click to expand...

Place a hidden text box named txtDateCnt in the Date group
header or footer section. Set its expression to =1 and its
Running Sum property to Over All.

A text box in the the report footer section can then display
the total number of date groups by using the expression:
=txtDateCnt
 
Back
Top