Saved Settings in reports – how does it work?

by Apr 5, 2018Reports, User Experience

Home 9 User Experience 9 Reports 9 Saved Settings in reports – how does it work?

Saved Setting in reports is one of the functionalities that are in the Business Central (and also in NAV) for a long time (since NAV 2015); However, many people do not know about this feature and what possibilities are offered.

Everyone knows that reports contain at the very beginning of the request page section called “Saved Settings” that allows the use of predefined filters or(as is more usually used as from my experience), only the automatically predefined filter created when the report was run for the last time.

Standard report request page with one predefined saved setting.

This field has a lookup to the page “1560, Report Settings” based on a system table “2000000196, Object Options”. The page is also available using “Search for page/Tell Me” as “Report Settings”.

Report Settings list page.

On this page, users (with the proper permissions) can modify, create, or delete saved settings for reports for all users. To create a new setting user can use the function to duplicate (action Copy) the existing one or create a blank configuration from scratch.

Saved Setting can be defined for a specific user (as is created automatically through report itself), or it can be shared with all users. To allow using of the saved setting for all users, an admin must set field “Share with all users” to Yes.

IMPORTANT: There is currently a bug in the system. If two saved settings for the same object that are used by one user have the same “Name”, the user won’t be able to select the one shared to all users. On the request page of the report, both configurations will be visible, but the one created only for the user will be used.

Recent Articles from the category

Report layouts in Excel? Yes!!!

Report layouts in Excel? Yes!!!

Everyone is surely aware of how strong Excel is as a software. It has been deeply ingrained in corporate operations worldwide, whether it be for assessing stocks or companies, creating budgets, or organizing customer sales lists. Usage of Excel Layout Due to the fact...

read more
Substituting standard reports

Substituting standard reports

Report objects cannot be extended in versions previous to the Business Central 2021 release wave 1 version when ReportExtensions object was introduced. Since then, many of changes we need to do in reports can be done without creating a new copy of object. On the other...

read more
Monitored Fields

Monitored Fields

Another new functionality introduced with the Business Central 2020 Wave 2 (with version 17.1 in November specifically) is called "Monitored Fields". This functionality is built over the original Change Log functionality and use the same tables and procedures;...

read more

Sign Up for News

Certifications

Highest certification
Microsoft Data Management and
also in D365 Business Central

Microsoft Certified: Dynamics 365 Business Central Functional Consultant Associate

See other certifications here