Count the Number of Records in a Report or Group
- Last UpdatedMar 15, 2023
- 3 minute read
Counts the number of records in a report or a group.
-
Create a new report
-
Bind the report to a data source.
-
Right-click anywhere on the report, select Insert Band and ReportFooter from the drop-down menus.
-
In the same way, add GroupHeader and GroupFooter bands to the report.
-
On the Field List window, click the Field List tab and select the required field item to be used as the report group header.
-
Drag and drop the selected field item onto the GroupHeader area of the report. A control is created which displays the name of the field item and the yellow database icon.
-
On the Field List window, click the Field List tab and select the required field item to be used as the report data.
-
Drag and drop the selected field item onto the Detail area of the report. A control is created which displays the name of the field item and the yellow database icon.
-
On the Detail area of the report, select the field item for which a group count is to be calculated. Hold down Ctrl and drag the field item onto the GroupFooter area of the report to create an exact copy.
-
On the Detail area of the report, select the field item for which a report count is to be calculated. Hold down Ctrl and drag the field item onto the ReportFooter area of the report to create an exact copy.
-
Click the Smart tag symbol at the top of the GroupHeader band to display the Tasks window.
-
Click the ellipsis next to Group Fields to display the GroupField Collection Editor window.
-
Click Add to add a new entry.
-
Set the Field Name property to the required field.
-
Set the Sort Order property (ascending or descending).
-
Click OK to apply the settings and close the Group Field Collection Editor window.
-
Select the label in the GroupFooter band and on the Properties window, click the Data tab.
-
Expand the Summary property.
-
Set the Running property to Group.
-
Set the Function property to Count.
-
Select the Ignore Null Values check box.
-
Select the label in the ReportFooter band and on the Properties window, click the Data tab.
-
Expand the Summary property.
-
Set the Running property to Report.
-
Set the Function property to Count.
-
Select the Ignore Null Values check box.
-
Click the Print Preview tab to display the result.
Refer to Create Layout Template / Report Definition and Bind Report to Dabacon Project Data for further information.