A repeater element can be used to repeat a certain part of the report depending on the report type for each value of a given set of levels. Levels Repeaters have one or more levels, each level representing a set of values to repeat over.
Each level has the following attributes:
Example: You have a Microsoft Excel Report (see Microsoft Excel Reports) and you want to repeat a worksheet for each value of the field "Year" in the datasource. In that case, you would create a repeater with a level that queries all values of the field "Year" and place it in the report template ; in the list of fields to filter, you would also add the field "Year", because you want each repeated section to be filtered to the year of the repeated worksheet. The reason why you need to explicitly specify the list of fields to filter (instead of Mail & Deploy automatically filtering that repeated field) is, that you could have report elements from various datasources in the repeated section and therefore you might need to filter fields different from the field the repeated values are taken from.
Settings
If the repeater is used in the context of a Microsoft Excel or Microsoft PowerPoint report, an additional setting Number Of Repeated Items may be set. This setting controls how many worksheets (in the case of a Microsoft Excel report) or slides (in the case of a Microsoft PowerPoint report) shall be repeated per repeated value.