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'?