Including sub reports in your report definition
When you create a report definition for a business object, it may be linked to one or more other business objects. You can include data from these linked business objects in the report. When a report on a primary business object contains a section that displays data from a linked business object, this section is called a subreport.
For example: orders are linked to a property. You could make a report on properties, including a subreport with orders per property.
Procedure
1. Open the TSI and selection level or step corresponding to the subject of the report, for example the Properties selection level of the Work Orders TSI if you want to create a report with properties, including a subreport on orders for each property.
2. From the Report action menu, select the Report option.
The Reporting window opens.
3. Click Add.
The Report definitions and settings window opens. In this window you can select the fields you want to include in your report definition.
| By using the horizontal and vertical sliders in this window, you can customize the panels' size as required. |
For more information on including 'normal' fields, refer to
To add a new user report definition.
For subreports, you can use either association fields or reference fields. For more information on these field types, refer to
Field types.
4. Select the association (or reference) field you want to include in your subreport, for example the Orders|Property field if you want to include a subreport with orders for each property.
5. Click Add subreport
, to add a subreport. | In a report definition, it is possible to define subreports down to a maximum of 10 levels. |
A subreport is added to your definition. In the Settings section of the window, you can make some settings for the subreport, such as font type and background color.
For more information on this subject, refer to
Making report settings.
From the Available fields section, select the fields you want to include in your subreport, for example Number and Description, and move them to the Selected fields section.
6. Make the required field settings for the selected fields, such as column width or alignment.
For more information on field settings, refer to
Making field settings.
7. Click OK to save your report definition.
8. To save the report in the required output format, click Save as.
You can copy an existing user report for convenience, and then reuse or modify it as needed.