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.
Technology Tips and News
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.
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