Finale Knowledge Base

What are the size restrictions and limitations for reports?

There are two firm limits when generating reports. Both will prevent the report from running.

  • Too many columns and filters to run

  • Too many rows to run


Too Many Columns and Filters Formula

The formula to calculate the limitation for too many columns and filters is: the number of column groups + number of filters ≥ 32

Formula diagram: number of column groups plus number of filters, greater than or equal to 32


Too Many Rows Formula

The formula to calculate the limitation for too many rows is: the number of rows * (number of regular columns + (15 * number of formula columns)) > 12,000,000.

Formula diagram: number of rows times regular columns plus 15 times formula columns, greater than 12,000,000


Report Efficiency

The report will run more efficiently and allow for a slightly higher threshold if columns of each data type are grouped together. For example, to improve the report shown below, Stock:, Product:, Order for stock:, and Product stock: would all be grouped together. Each "group" of column types is considered one group for the calculation, so by organizing the report below by group, you can reduce the total number of groups from 6 to 4.

Report setup with Stock, Product, Order for stock and Product stock primary columns out of group order and four Stock calculated columns