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:

1. Go to Report -> Parameters.
2. 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.

The post Set SSRS Report Parameter to allow null values in D365 Operations appeared first on CloudFronts - Microsoft Dynamics 365 | Power BI | Azure.