Repeater Elements

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:

Datasource FieldThe datasource field (see Fields) from which to query values to repeat.
Field Value Selector The field value selector that determines which values of the datasource field shall be used for the repeater.

All Values.

If you use this selector, all values of the datasource field will be used for the repeater, regardless of the current filter state of the datasource.

Applicable Values. 

If you use this selector, only those values of the datasource field will be used for the repeater which is compatible with the current filter state of the datasource.

Filtered Values. 

If you use this selector, only those values of the datasource field will be used for the repeater to which the datasource field is explicitly filtered.
Sort Order 

This setting determines in which order the values will be processed by the repeater.

None. 

No specific sort order will be used and the values will be used in the exact order in which they have been read from the datasource.


Ascending. 
The values of the datasource field will be processed by the repeater in ascending order.

Descending. 

The values of the datasource field will be processed by the repeater in descending order.

Fields to FilterA list of datasource fields to filter before the report elements contained in the repeated section of the report will be evaluated.
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.

T
Team is the author of this solution article.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.