Skip to main content

Tutorial: Creating a Report with a Sub Report in Report Designer

T
Written by Tim Sublette

The articles in this section of the Knowledge Base involve working with Sub Reports for display in your reports. To learn more about Sub Reports, and how to access this section within the Report Designer, see Understanding Sub Reports in Report Designer. This article features a step-by-step tutorial demonstrating the steps necessary to add a sub report to a report.

  1. Open Report Designer.

  2. Add a Report Title Band if desired.

  3. Add a Data Band and set the Data Source to the Products table.

    1. Add a text component to this band and select Products > Name from the Data Column tab.

  4. Add a Child Band beneath the Data Band.

    1. Add a Sub Report component to the Child Band. A new page is automatically added to the report template when the sub report component is added.

  5. Go to the new page of the report template, and place a Header Band with text components for your column labels (In this case, Height, Width, Depth). Place a Data Band with text components for the list of the heights, widths, and depths of your products (in this case, the Data Columns are Products.Height, Products.Width, and Products.Depth). See Figure 04.

    1. Set the Master Component of the Data Band to DataBand1. The Master Component is selected instead of selecting a Data Source. Leave the Data Source unassigned.

  6. Run your report. The results should resemble Figure 05.


Did this answer your question?