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.
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.
As a result of this activity the executed report will include a result based on the sheet repeater selected.
Select Display Items
Apply Repeater
Apply Filter Criteria
Apply Microsoft Excel Functionality
To prepare an IFS Business Analytics Report using sheet repeaters:
Use of one the following method to remove a repeater: