Set SSRS Report Parameter to allow null values in D365 Operations
Introduction:
Reports are used to see summary of data. We also set parameter to filter data but at times we don’t want to filter using a parameter and keep it as blank. By default, parameter values are always mandatory in D365 Finance and Operations, Enterprise Edition. In this blog article, we will see how we set property to allow null values to a parameter in SSRS Report.
Steps:
- Go to Report -> Parameters.
- Select the Parameter which you don’t want to be mandatory.
- Go to Properties -> Nullable.
- Set the value to True. This will allow you to pass null value.
This is how you can make the report parameter as optional.
Related posts:
Use Database Access Intent List to Boost Performance in Business Central
Enabling Physical Negative Inventory in Dynamics 365 Finance and Operations
Advance warehouse management – Warehouses and Locations in Microsoft D365 F&O - Part 2
Advance warehouse management – Item Creation process in Microsoft D365 F&O - Part 1
