Adding related records

You can use the Report Designer to add a RelatedReport element in your report. A RelatedReport allows you to include related data in your report. The RelatedReport element will only be accessible if the layer or table that you are creating the report on participates in a relate or relationship class.

Steps:
  1. Open a report in the Report Designer.
  2. From the list of design elements, click RelatedReport and drag the element into a section (typically the Details section) on the report layout.
  3. Click the RelatedReport element and choose the relate that you want to use from the Relationship property on the properties grid.
  4. Double-click the RelatedReport element to open a design view for the related report.

    PageHeader and PageFooter sections are not generated for RelatedReport elements.

  5. Click the Run Report button to preview the report.
TipTip:
The existence of related reports is indicated by a tab with the name of the relate above the report sections. If you click on a related report, you are only able to see its parent report.
TipTip:
Reports can have multiple related reports, and likewise, you can include related reports within another related report (as long as the data source participates in a relationship).
7/5/2012