Report Limit
Teddy Herryanto (Th...
14,284
Super User 2025 Season 2
Like
Share
Report
To ensure the availability and quality of Business Central services, Microsoft put a certain limitation on the reports, such as Max Execution Timeout to prevent report running continuously for days. You can see this limitation when you run any report under Advanced section.
If you go over the limit, the report will be canceled. Below is an example where I setup the Maximum Rows as 2. Because the document has more than 2 rows, the report resulted in error.
If you want to setup the default for each report, you can use Report Limit page. In this page, you can specify the Report Timeout, Max Rows, and Max Documents.
You can see the explanation of the field below or in this link.
| Setting | Description | Limit |
|---|---|---|
| Default max documents | The maximum number of documents that can be merged in a report using a Word layout. Users can override this setting on a report-basis from the report request page. If exceeded, the report will be canceled. Developers can override this setting by using MaximumDocumentCount property of a report. Client users can do the same when running a report from the report request page | 200 |
| Max documents | The maximum number of documents that can be merged in a report using a Word layout. If exceeded, the report will be canceled. | 500 |
| Default max execution timeout | The maximum execution time that it can take to generate a report by default. Users can override this setting on a report-basis from the report request page. If exceeded, the report will be canceled. Developers can override this setting by using the ExecutionTimeout property of a report. Client users can do the same when running a report from the report request page. | 6 hours |
| Max execution timeout | The maximum execution time that it can take to generate a report. If exceeded, the report will be canceled. | 12 hours |
| Default max rows | The maximum number of rows that can be processed in a report by default. Users can override this setting on a report-basis from the report request page. If exceeded, the report will be canceled. Developers can override this setting by using the MaximumDataSetSize property of a report. Client users can do the same when running a report from the report request page. | 500,000 |
| Max rows | The maximum number of rows that can be processed in a report. If exceeded, the report will be canceled by the server. | 1,000,000 |
Note that the limits you set cannot exceed the maximum system limit. One of the example is Max Rows, if you set as 2 million rows, the 1 million Max Rows is still in effect.
This was originally posted here.
*This post is locked for comments