This section of the report features static controls including Labels, a Picture, a Line, and a Shape control. The report header prints only once on the first page of the report, thus report title, company information, and a logo are added in this section.

The page header section contains static Label controls that print at the top of each page and serve as column headers for the group header sections.

This group header section has the DataField property set to CategoryName. This setting, along with data sorted by the same field, produces a report grouped by category. The section contains one bound TextBox control to display the category name at the beginning of each group. The section's UnderlayNext property is set to True so that the category prints to the left of the top line of data instead of above it.

Although this group header contains no controls and is hidden by setting the Height property to 0 and Visible property to False, it still performs two important functions. First, the DataField property is set to ProductName, to sort the data inside each category by product, and second, the related group footer section displays the bulk of the data for the report.

The detail section of this report is hidden by setting the Height property to 0 and Visible property to False, but it does contain four bound fields whose values are used in the code. In the Detail Format event, the value from the hidden txtDetProduct TextBox is collected and passed to the _sProductName variable. For more information on section events, see Section Report Events.

This group footer section displays the bulk of the data for the report in TextBox controls that have values passed in code, or are bound to fields from the report's Fields collection (see FetchData and DataInitialize events in the code) using the DataField property.

In the gfProduct Format event for the inner group footer section, the product name collected from the Detail Format event is passed to the txtProduct TextBox. The Value for the txtPQTDChange TextBox is calculated by subtracting the prior year's quarter-to-date sales figure from the current quarter-to-date sales figure. The BackColor of the txtPQTDChange TextBox is set to Red if the value is negative.

The total units and sales for each product is summarized using the following properties.

• SummaryFunc: Sum (the default value)
  Adds values rather than counting or averaging them.
• SummaryGroup: ghProduct
  Summarizes the values that fall within the current product group.
• SummaryRunning: None (the default value)
  Ensures that this value is reset each time the product group changes.
• SummaryType: SubTotal
  Summarizes the current group rather than a page or report total.

This group footer section displays totals of the gfProduct data in TextBox controls that have values passed in code, or are bound to fields from the report's Fields collection (see FetchData and DataInitialize events in the code) using the DataField property. 

The total units and sales for each category is summarized using the following properties.

• SummaryFunc: Sum (the default value)
  Adds values rather than counting or averaging them.
• SummaryGroup: ghCategory
  Summarizes the values that fall within the current category group.
• SummaryRunning: None (the default value)
  Ensures that this value is reset each time the category group changes.
• SummaryType: SubTotal
  Summarizes the current group rather than a page or report total.

This section is not used, so it is hidden by setting the Height property to 0 and/or Visible property to False. Otherwise, it would print at the bottom of each page. The section cannot be deleted, because the related PageHeader section is in use.

This section is not used, so it is hidden by setting the Height property to 0 and/or Visible property to False. Otherwise, it would print once at the end of the report. The section cannot be deleted, because its related ReportHeader section is in use.