Filter reports more efficiently
|Enabled for||Public preview||General availability|
|End users, automatically||Aug 1, 2019||Oct 1, 2019|
As the business grows, so do the data sources powering reports. This increases the need for control over precisely how much data is processed.
When running a report in Business Central, users are presented with a request page where they can specify various options and filters.
Filtering report data
The filter experience has been greatly improved with features similar to filtering lists that allow you to:
- Add as many filtered fields as you like by choosing any field from the source table or typing to quickly find the field.
- Get assistance with specifying filter values using look-ups and similar pickers, including filtering on multiple option-field values.
- Create complex filters using operators, ranges, formulas, and filter tokens.
Business Central remembers the filters you applied and also allows you to choose from report settings you made earlier.
One of the most popular features of Dynamics NAV is now also available for reports. Reports often display aggregated or computed values through FlowFields, such as currency amount totals. With this release, Business Central allows you to apply filters to one or more dimensions that influence computed values.
The improved experience is consistent across report objects as well as XmlPort objects and screens originating from the RunRequestPage command or FilterPageBuilder command.
Tell us what you think
Help us improve Dynamics 365 Business Central by discussing ideas, providing suggestions, and giving feedback. Use the forum at https://aka.ms/bcideas.
Feature exploration (video)