Apply Sheet Repeaters

Explanation

Sheet repeaters are used to repeat a display item into a number of Microsoft Excel worksheets using the available report design. For example, if the selected sheet repeater is Code B and it represents cost center, then the report will display all the available/selected cost centers in the database for the report design in the work sheet. It is only possible to select one sheet repeater per workbook.

Prerequisites

In order to perform this activity, a basic report design should be created. The basic design should include either a measure or a light item.

System Effects

As a result of this activity the executed report will include a result based on the sheet repeater selected.

Related Process Models

Apply Design Elements
 

Related Activity

Select Display Items
Apply Repeater
Apply Filter Criteria
Apply Microsoft Excel Functionality

Procedure

To prepare an IFS Business Analytics Report using sheet repeaters:

1. Select the sheet which needs to be repeated.
2. Drag a sheet repeater item from the Display Items pane into the Display Items field in the Sheet Repeater tab.
3. If you want to specify a name for the worksheet, select the User defined sheet name check box and enter the name in the Prefix field.
4. Specify a sorting order by selecting a value for the Sort field.
5. Click Run.
6. Compare the executed report with design.
7. To modify the design select Go to Design.

To remove a repeater:

Use of one the following method to remove a repeater:

• Select the row in the Repeater tab and delete.