Custom report limits

Performance-related limitations

To prevent unexpected failures when running very large custom reports, Alloy imposes some safety limits on the size of data sources and document layouts.

Data source limits

Each data source is limited to 500,000 rows of output. This limit applies to each single data source in the report.

For example, if a report contains two AQS query data sources and one Join data source data source, the 500,000 limit applies to each of them separately.

In other words, you can't generate more than 500,000 rows of items via an AQS query data source or generate a Join data source with more than 500,000 rows.

Document limits

The document layout limits depend on the document type.

Tabular document type

Tabular (CSV) reports are limited to 500,000 rows of output for each Table control added.

Flow document type

Flow documents vary in design and content, so their output is limited based on a point scoring system.

Flow reports are limited to 240,000 points in total, 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.

Score calculation example

Imagine a Flow document with a Repeater control that contains three Field controls, a Map control and a Table control. When the report runs, 200 items are processed. We assume that these items will be listed as table rows, with their 15 attributes listed as columns.

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 had the same number of items (200 per repeater), you could place up to 73 Repeater controls before reaching the limit, as 73 * 3256 = 237,688.

Error Messages

If these limits are exceeded, the report will fail to generate, with the reason provided by one of these 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