CODEWITHSUNDEEP
ssrs-2008reporting-services
VInayK
VInayK

Reputation: 1559

SSRS report parameters

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

Upvotes: 0

Views: 3179

Answers (2)

Touseef
Touseef

Reputation: 424

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)

Upvotes: 0

adopilot
adopilot

Reputation: 4520

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

Upvotes: 2

Related Questions