In my SSRS report I have 4 parameters that the user can choose from: CD, Condition, OrderID and Begining and End Date (ProjectDate). The user will always choose CD and Condition, but only sometimes will they choose OrderID and Beginning and End Date as part of the parameter criteria. Is there a way to make my DataSet query recognize that the user has not put anything in for either one of the parameters of OrderID or Beginning and End Date?
Here is the query in my dataset:
SELECT CD,CONDITION, OrderID, ProjectDate
Where ((Order.CD IN (:CD)
AND Order.CONDITION IN (:CC))
OR (Order.ORDERID IN (:WOID)
OR (ORDER.ProjectDate >= to_date(:BEGDATE, 'MM/DD/YYYY'))
AND ORDER.ProjectDate <= to_date(:ENDDATE, 'MM/DD/YYYY')))