Adding repeating sections to reports
Who is this article for?Administrators responsible for configuring reports.
Administration module access is required.
Repeating sections are collections of fields that repeat on a record, making it easier to display data in a single collection.
This article explains the various types of repeating sections and shows you how to add them to reports.
1. Overview
Some examples of a single level of repeating sections include:
- Stage Information - CA/PA or Incident records can include multiple stages. A repeating section can be used to pull in fields for every stage on that record.
- Approval Cycle Information - Documents will generally be submitted for approval and then withdrawn following a rejection. When they are resubmitted, this will create a second approval cycle. A repeating section can be used to display the information associated with the approval cycles.
- Training Events - Users often have training records, some of which can be renewable. A repeating section can be used to display all events relating to the user.
In some cases, you will also need to add a repeating section within a repeating section.
Some examples of two levels of repeating fields are:
- Stage Actions - CA/PA and Incidents can have many stages, and likewise, stages can have many actions. A repeating section can be added to the stages section to pull in actions for each stage.
- Approval Items - Each approval cycle will usually have more than one approver. A repeating section can be added to pull in all items for each cycle.
2. Adding repeating sections
To add a repeating section:
- Access the Administration module.
- Select Customisation.
- Choose Messaging.
- Click the Edit button of the email you want to add fields to.
This will open Report Designer. - Open the Configuration menu.
- Select Insert Detail Report Band (under Actions).
- Select the band.
- Set Data Source to Document.
- Set Data Member to your repeating section.
- Click Data.
- Browse to the hierarchy level that matches your repeating section.
- Add any fields you require.
- Click Save (in navigation menu).
1. Overview
Some examples of a single level of repeating sections include:
- Stage Information - CA/PA or Incident records can include multiple stages. A repeating section can be used to pull in fields for every stage on that record.
- Approval Cycle Information - Documents will generally be submitted for approval and then withdrawn following a rejection. When they are resubmitted, this will create a second approval cycle. A repeating section can be used to display the information associated with the approval cycles.
- Training Events - Users often have training records, some of which can be renewable. A repeating section can be used to display all events relating to the user.
In some cases, you will also need to add a repeating section within a repeating section.
Some examples of two levels of repeating fields are:
- Stage Actions - CA/PA and Incidents can have many stages, and likewise, stages can have many actions. A repeating section can be added to the stages section to pull in actions for each stage.
- Approval Items - Each approval cycle will usually have more than one approver. A repeating section can be added to pull in all items for each cycle.
2. Adding repeating sections
To add a repeating section:
- Access the Administration module.
- Select Messaging (under Customisation).
- Right-click the email you want to add fields to.
- Click Edit.
- Click Edit... (next to Message body).
This will open Report Designer. - Browse to Report Explorer.
- Right-click the report title.
- Select Insert Detail Report.
This will display the options available.
- Select your repeating section.
This will automatically add the required bands and default fields to the report. - Drag and drop the fields from the field bank section into the Detail band (under the Detail Report band).
- Click Save & Close.