Home Forums Reporting Services Reporting Services 2008 Development Parameter for Picking from Two Different Types of Date Ranges RE: Parameter for Picking from Two Different Types of Date Ranges
mikehunsaker
SSC-Addicted
Points: 454
More actions
March 20, 2013 at 8:36 am
#1598936
Could you use the ISNULL function like:
...and (YearVal In (ISNULL(@CalYear, 0)) or FYearShortVal In (ISNULL(@SalesYear,0)))