Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jassie
Constraint Violating Yak Guru
332 Posts |
 Posted - 2014-02-07 : 17:38:04
|
| In an SSRS 2008 R2 report, there are 5 parameters that the user currently is required to enter. I am addiong a new option to a parameter called 'State' where there is suppose to be a new option to select 'NOT in USA'. When the user selects this new option, there is a parameter area called 'City' where the user is not required to select a value.Thus in this situation, for the parameter called 'City', what should I change? Should I allow 'null' to be a default option? The following is the part of the main query that deals with the parameters: AND En.startyear = @startYear AND En.endyear = @endYear AND IsNull(En.State,'') in (@State) AND IsNull(EN.City,'') in (@City) AND cust.prod in (@prod_code) How would I change the main query to not use the value in 'City' in the main query where the option seleected for 'state' is 'NOT in USA'? |
|
|
|
|
|
ssrs 2008 use dependent parameters sometimnes