SSRS URL Paramter Value does not match with report parameter Values

Question

Hi,

We have rdl report and passing a multiple paramter values through URL. When the passed values exists in report parameter values then report displayes properly.

But when we pass the values through URL which doesn't exists in report parameter value then it throws an error saying parameter value is missing.

The reports db and the application db through which we display the reports are different. how do we address this issue.

pls help.

regards, hari.

Answer 1

I would try adding default values to your parameters, or allow nulls for your parameters. This way the report will not complain when no value is passed for a specific parameter.