Reports:Count Records Printed

Wednesday, May 16, 2001 10:53:00
 home

This example will tell you how to make a report print "254 records printed" at the end. I find this very handy for making sure that the report is printing and querying everything properly. You may have your own needs.

  • First, with the report open in design view, create a text box in the "Detail" section of the report. Set the following properties:

    TabPropertySetting
    FormatVisibleNo
    DataControl Source=1
     Running SumOver All
    OtherNamestCounter
  • Make sure to remove the label attached to the text box.

  • In the "Report Footer" section, add a text box and set the "Data........Control Source" property to =stCounter.

    Notice that as you print the report, near the end it will tell you how many records total were printed.