Dynamics 365 Business Central: Report Limits management page

Dynamics 365 Business Central

Hi, Readers.
To ensure the availability and quality of Business Central services, there are limits on certain operations. From 2020 release wave 1, users can set limits on the execution time, rows, and documents for reports.

When the limit is reached, the server cancels the operation.

So, as an administrator, is there a way to set limits for all reports at the same time?
Yes, you can find the Report limits page in Business Central.

page 9882 “Report Res. Govern. Settings”

More details:

You can set report timeout, max rows, max documents like on the request page of the report.

When entering the timeout, you can use for example 1H, 5M, 5S fast input, which is not possible on the Request page.

The parameters you set on this page will be automatically reflected in the Request Page. But please note that the limits you set cannot exceed the system limit, such as Max documents is 500. If you set more than 500, it will not take effect.

Isn’t it very easy to manage? Give it a try!!!

PS: Report limits

SettingDescriptionLimit
Default max documentsThe 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 documentsThe 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 timeoutThe 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 timeoutThe maximum execution time that it can take to generate a report. If exceeded, the report will be canceled.12 hours
Default max rowsThe 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 rowsThe maximum number of rows that can be processed in a report. If exceeded, the report will be canceled by the server.1,000,000

END

Hope this will help.

Thanks for reading.

ZHU

コメント

タイトルとURLをコピーしました