Search code examples
reporting-servicesssrs-2008-r2

How to set default value of parameter to Null in SSRS?


Can anyone tell me how to set default value of parameter to Null.

I tried this.

=Parameters!rp_GIIN.Value="",nothing,Parameters!rp_GIIN.Value)

Solution

  • You can set Default value to Null like this way, just go to the report parameter ,right click on it and go to Parameter Properties and select Default values tab and set (Null)

    enter image description here

    Expression could be,

    =IIF(Parameters!rp_GIIN.Value="",Nothing,Parameters!rp_GIIN.Value)