› Dynamics 365, Enterprise › Set SSRS Report Parameter to allow null values in D365 Operations

Set SSRS Report Parameter to allow null values in D365 Operations

Sohagani Shah
ERP Developer
Published on December 29, 2017
Category: Dynamics 365, Enterprise

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.



Leave a Reply

Your email address will not be published. Required fields are marked *

Time limit is exhausted. Please reload the CAPTCHA.

Looking for a demo?

We will get back to you very soon!
We promise.

  • This field is for validation purposes and should be left unchanged.