SSRS report parameters

0
votes

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...

2
ssrs-2008reporting-services
Basically i need to RUN the report without selecting any parameter from drop downs. IF value is not selected, the SQL procedure will return all details of all Datasources.... – VInayK

2 Answers

2
votes

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
0
votes

to verify date, you can use this method too: make two rectangle; insert table/matrix in first rectangle in second rectangle insert msg like "Selected Date is not valid, please select correct date" or "Start Date should be less less than End Date"

put appropriate msg, and make condition in 1st rectangle where all tables/matrix is there

iif( Parameters!StartDate.Value < Parameters!EndDate.Value,false,true)

in second rectangle where Error msg is inserted write this:

iif( Parameters!StartDate.Value < Parameters!EndDate.Value,true,false)