Set SSRS Report Parameter to allow null values in D365 Operations - CloudFronts

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.
  3. Report Parameter

  4. Go to Properties -> Nullable.
  5. Set the value to True. This will allow you to pass null value.

Nullable Property

This is how you can make the report parameter as optional.


Share Story :