Report limits
How to use nested repeater controls
Overview
In order to prevent unexpected failures when running custom reports, Alloy has limits to Custom Reports for data sources and report document layout.
Data Sources limits
Each data source that you create is limited to 500,000 rows of output. This data limit applies to each single data source in the report. For example, if a report includes two AQS query data sources and one Join data source, then the 500,000 limit refers to each of them. You cannot generate more than 500,000 rows of items via an AQS query data source or generate a Join data source that will have more than 500,000 rows.
Layout limits
The limits within document layouts are dependent on the document type.
Tabular document type
Tabular (CSV) reports are limited to 500,000 rows of output. A Tabular Report is driven by a single data source, the limits for this report are related to the data source limits described above.
Flow document type
Flow documents can be varied in design and content, which can be included in a Flow Report (HTML + PDF). To manage these reports the output is limited based on a point scoring system.
Point scoring system
Flow reports are limited to 240,000 points where the points are determined by the number of rendered controls in the report.
The points for each control type are as follows:
- Text = 1 point
- Field = 2 points
- File link = 2 point
- Image = 50 points
- Map = 50 points + number of items added to the map
- Table = number of rows * number of columns i.e. 1 point for each cell
- Repeater and Horizontal/Vertical stack = sum of points of components added into them.
For a Flow report with a Repeater control that contains three Field controls, Map and a Table, where the map has 200 items. We assume that these items are listed as table rows with details of their 15 attributes as columns.
Cost of each Repeater control would then be sum of
Field = 3 * 2 = 6
Map = 50 + 200 = 250
Table = 200 * 15 = 3000
Repeater total cost = 6 + 250 + 3000 = 3256
In this scenario, assuming that each repeater with a field, map and table, has same number of items (200 per repeater), you would be able to place up to 73 repeater controls in the Flow report before reaching the limit, as 73 * 3256 = 237,688.
Error Messages
If these limits are exceeded, the report generation will fail and the reason for the failure will be given by one of the following error codes:
E1621931682 AQS Query data source over the limit E1621931923 AQS Join data source over the limit E1621932048 AQS statistics data source over the limit E1621932238 Join data source over the limit E1621938678 Flow document over the limit E1621936959 Tabular document over the limit