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


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.


Optimizing a Report

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 optimize 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.