SSRS report parameters

Question

In my SSRS report there are 2 parameters called DataSourceIDList and ReporterIDlist.

DataSourceIDList : is a drop down list and this will populate based on SQL query.

ReporterIDlist : is a drop down list and this will populate reporters based on selected Datasourceid from DataSourceIDList and this is also a SQL query.

both parameters are optional fields but when i am running the report i am getting error called "Please select value for DataSourceID" but i set the property for that parameter as allow NULL values

and same problem for ReporterIDlist also.

Please suggest your suggestion....

Thanks in advance...

Answer 1

I think that SSRS will not allow you NULL value if parameter have datasource.

Trick that I do when I need all values that is: I change data source for parameters that is in list have null, or ( 0) value, and option select ALL, and after that I set default value to null so users do not have to touch parameters before it call it

Something like this,

Select 1,null as ValueOfParam,'All values' as TextOfParam
union all
select 2,id,name from myDatasourceThatHaveParamValues
order by 1,name