SSRS Report 2012 and Null Parameters

I have a SSRS 2012 report where all parameters can be null. 

If I select Preview in Visual Studio, it will run the report immediately with NULL values for all parameters.

Is there anyway that I can avoid this.

Thanks in advance.

September 11th, 2015 4:36pm

Hi Miguelh, 

According to your description, you don't want to run the report with null parameters, right? 

In Reporting Services, if we selected "Allow null value" for the parameter, the report parameter value is null as default. In you scenario, have you set all parameters values to null? If so, you can uncheck the checkbox and set default values for the parameter. And then the report will render the data with the default report parameters values. You can also hide the parameter. 

If you have any other question, please feel free to ask. 

Regards,
Shrek Li

Free Windows Admin Tool Kit Click here and download it now
September 13th, 2015 9:46pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics