Skip to main content

#msdyn365bc - Changes related to Reports in 2020 Wave2.

Hi Readers,

In series of articles about What's new in Business Central 2020 Release Wave2, in this article we will see what changes are done for Reports.

This article we provide all different ways that we can set these soft limits for Report Executions in business central.

Report performance and easier to access are two areas that Microsoft worked during this release. 

This also adds an extra step for developer to make sure that performance of the reports is within the soft limits.

There are two changes that are added in Business Central related to Report Execution.

1. Ability for developers and end users to override the system setting for maximum time a report can run.

This feature enables a Business Central host to set resource limits in the system, without disrupting users who might need to exceed the limits from time to time.

Who and Where can set these Values?

A system administrator can set soft and hard limits on report execution time on the server.

  • This is only allowed on-prem.
  • You as administrator can set these values in Service Tier with Six Setting Listed Below.
    • ReportMaxRows
    • ReportTimeout
    • ReportMaxDocuments
    • ReportDefaultMaxRows
    • ReportDefaultTimeout
    • ReportDefaultMaxDocuments

Default Values are what will be available in Request Page.

ReportMaxRows - Specifies the maximum number of rows that can be included in this report.
ReportTimeout - Specifies the maximum time it can take to render the report.
ReportMaxDocuments - Specifies the maximum number of documents that can be included in this report.

If any of these parameter get exceeded during execution, the report will be canceled.


A developer can set a maximum timeout in report metadata.
  • During Report Development in AL, Developer can set these values in the Report Design.

That's not it End users at runtime, can override the metadata setting.

  • In Every Report Request page there is a New tab available to override the default values that are set by administrator in Service Tier or by Developer during design time.


The soft limits set on the Business Central online server are expected to be six hours for version 17.0, with a goal of one hour.

Another Report related feature added is - 

Report request page can open multiple previews.

  • With Business Central 2020 release wave 2, a report request can open multiple previews one by one without closing the main window. This unblocks users who try out different report parameters, so that they stay focused on a given report and become more productive.
  • When a set of parameters is finalized, the user has an opportunity to print or export the report. Printing or downloading is also possible from the report preview page.

Hope you find the information useful. Let me know your views as comment to this article.

Stay tuned for more.

Regards,
Saurav Dhyani

Comments

Popular posts from this blog

BC 21 and Higher - PowerShell Cmdlet (Replacement of Business Central Administration).

Hi Readers, As discussed in last article about deprecating of Business Central Administration, there are few common actions that we use in administration till Business Central 20. For our on-prem customers, we will still require doing activities. As Microsoft suggest we need to start using PowerShell cmdlet.    Let's see how to do those via PowerShell, or Administration Shell. I will be keep adding commands as you comment to this article.

Send Mail with Attachment From Navision.

Hi all, We have seen how to save a report into PDF and how to send mail to a customer. Let's link these two post in one i.e. Mailing statement to a customer into PDF Format. This article is part of the Series. Please Refer  Table of Content here . If you have the old objects set let me brief you what I will be changing - 

MSDYN365BC - Data Upgrade To Microsoft Dynamics 365 Business Central on premises.

Hi Readers, We have already talked about the number of steps for upgrading to Business Central on Premises from different NAV versions. After that article, I received multiple requests for an article which list down steps for Data Migration. In this article, we will discuss steps of data migration to MSDYN365BC (on-Prem) from NAV 2017. For this article, I am considering a Cronus Demo Database without any customization. For an actual upgrade project, we will have to complete object merge using compare and Merge process. After the Merge Process, the next step is data migration. Let's discuss those steps. Direct Upgrade to Microsoft Dynamics 365 Business Central (on-Prem) is from following versions - 1. NAV 2015. 2. NAV 2016. 3. NAV 2017. 4. NAV 2018.