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

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 - 

Future - What Next After NAV 2016. Code Name - Madeira...

Hi All, While Browsing web I came across some article which says about next release of Microsoft Dynamics NAV. Let's see the History of Code Names Given to Previous Version  - NAV 2013 - Code Name 'Sicily' NAV 2015 - Code Name 'CRETE' NAV 2016 - Code Name 'CORFU' And as we all know that all these are the Islands.

Download Microsoft Dynamics Business Central on Premises 2020 Wave 2 Release.

 Hi Readers, As Expected Microsoft have released #msdyn365bc 2020 wave 2 is available.  This article provides details of the new release. The 2020 release wave 2 for Business Central delivers a wealth of new features. Read What's new in 2020 Release Wave 2 here .  Dynamics NAV Customers upgrading to Business Central on Prem will be able to run business central on premises, move to cloud or choose a hybrid approach.