InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 00:41:01 GMT20http://www.sqlservercentral.com/Forums/Topic1429514-1633-1.aspxCould you use the ISNULL function like:[code="sql"]...and (YearVal In (ISNULL(@CalYear, 0)) or FYearShortVal In (ISNULL(@SalesYear,0)))[/code]Wed, 20 Mar 2013 08:36:50 GMTmikehunsakerhttp://www.sqlservercentral.com/Forums/Topic1429514-1633-1.aspxHello all,I'm trying to set two - optional parameters - one for calendar year and one for sales year. The user needs to pick dates that are either a Calendar Year or a Sales Year. The code works in the query allowing a null value for either but not both, but when run in the report, it wants paramaters for both.Here's the dataset code:[code="plain"]...and (YearVal In (@CalYear) or FYearShortVal In (@SalesYear))[/code]Parameters are both set to multivalue and allow blank value. The available values are hand entered (specify values) - for example - in the Sales Year, the first label is 09/10 and the text value is 09/10, etc. for five entries, Calendar Year is similar - 2009, 2009, etc. I tried adding a blank label and empty value (not null or 0) to each of the value lists, but that didn't work either.What am I missing?Thank you.JNMMon, 11 Mar 2013 15:47:08 GMTservice 87594