When running a report, a user can choose a filter for the pre-defined fields or replace an existing filter field with a new one, but a user can't add additional filter fields. For example, the Inventory Valuation report offers three field to filter on. Let's say the user makes use of these three fields but requires now a fourth field to filter on. This is currently not possible.
Comments
The most important field - Location was missing in Inventory Valuation Report.
I was available in RTC.
Please put this back to BC on Cloud.
Category: Reports and Business Intelligence
When presented with a list of fields to pick from, It would be nice if the fields have an attribute bit of "Has Data"
and the search for field has an option to hide all fields in this table that do not have any populated in the table.
Category: Reports and Business Intelligence
This is a must-have, especially for users coming in from RTC.
Also, functionality of some standard reports is severely limited by not allowing Filter fields other than what is explicitly set through ReqFilterFields setting.
E.g. Report Suggest Vendor Payments allows filtering Vendor Ledger Entries using FlowFilters Currency Filter, GD 1 Filter and GD2 Filter from Vendor.
In BC Web Client user can't set these filters at all, as only No. and Payment Method Code (which are not flowfilters)are set for filtering.
Category: Reports and Business Intelligence
Great! We have 2 customers that are missing limit total filter in rep 1001. Tks!!
Category: Reports and Business Intelligence
No, you can't add any more fields on a report data item. That's my point.
Category: Reports and Business Intelligence
You can use Add Filter for any data item with filter fields. This is also available on Inventory Valuation report.
Category: Reports and Business Intelligence
Business Central Team (administrator) on 5/17/2022 1:19:40 PM
Thank you for your feedback. We released this feature as part of the functionality in Business Central 2019 release wave 2. Please refer to the following link for more information: https://docs.microsoft.com/en-us/dynamics365-release-plan/2019wave2/dynamics365-business-central/powerful-filtering-capabilities-reports Your help was greatly appreciated, Mike Borg Cardona Program Manager, Microsoft