Count the Number of Records in a Report or a Group

To count the number of records in a report or a group, follow these instructions:

1. Create a new report or open an existing one.

2. Bind the report to a data source.

3. Add a Report Footer band to a report. Right-click anywhere on report and in the Context menu, point to Insert Band and select ReportFooter.

   

4. In the same manner, add GroupHeader and GroupFooter bands to the report.

5. Drop the required data fields from the Field List onto the Report bands.

   

6. Click the field for which the number of records will be calculated to select it.

7. Then hold down CTRL and drag the field onto the Group Footer area to create an exact copy of the label, which will display the number of records for a group.

   

8. In the same way, create a copy of this field in the Report Footer area, to display the number of records for the report.

9. Click the Smart Tag of the GroupHeader1 band, and in the displayed actions list, click the ellipsis in the Group Fields section.

   The GroupField Collection Editor window is then displayed.

   

10. In this window, click Add, to add a new grouping field, and set its FieldName property to the required field.

11. To apply the settings and close the window, click OK.

12. Select the Label in the Group Footer area, and in the Property Grid, expand the Summary property.

    

13. Set the Running property to Group, the Function property to Count and (if required) the Ignore Null Values property to Yes.

14. Set the Format String property to Products in the Group: {0}.

15. Similarly, select the label in the Report Footer area, and in the Property Grid, expand the Summary property.

    

16. Set the Running property to Report, the Function property to Count, the Ignore Null Values property to Yes and the property Format String to Products in the Report: {0}.

    The report is now complete.

17. Switch to the Preview tab to view the result.