Collapse All Expand All

To show only summary data in a report, set the Detail section's Visible property to False or set its Height to 0. The Detail section still processes, but only the the summary fields in the GroupHeader and Footer sections are displayed.

To create a summary report

1. With the Detail section selected in the Properties window, set the Visible property to False.
2. Right-click the design surface of a report and select Insert, then Group Header/Footer to add a group header and group footer section.
3. With the group header selected in the Properties window, drop down the DataField property and select the field on which to group the report.
4. Add a TextBox control to the GroupFooter section, and set its properties as follows:
   • DataField: the field that you want to summarize
   • SummaryGroup: the name of the GroupHeader section
   • SummaryRunning: Group
   • SummaryType: SubTotal

To display a grand total at the end of the report

1. Right-click the design surface of a report and select Insert, then Report Header/Footer to add a report header and report footer section.
2. Add a TextBox control to the ReportFooter section, and set its properties as follows:
   • DataField: the field that you want to summarize
   • SummaryRunning: All
   • SummaryType: GrandTotal