jcrawf02 (1/11/2012)
Meaning that you want to be able to pick all states? (by making no selection) if so, then create your statement dynamically and only drop in the state if selected. If that's not what you want, please clarify.
Excuse me but I have written a lot of reports in many different tools but that is not the case with SSRS.
I did not know that you had the option to select all states until I checked the multi-select check box.
So please disregard that statement.:-)
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/