Forum Discussion
anmolmalviya05
Super User
Super UserParameters in SSRS report
Hello Everyone, I have created a ssrs report using below query Select * from orders o where o.ordername in @ordername and o.productname in @productname I have two parameter in my ssrs repo...
What do you imagine shoul be the SQL query, if one or both parameters are blank?
Are these multiselect parameters? If so, I dont believe you can leave multiselect parameter blank. Probably what you want is to have Select all as default in multiselect parameter, effectively not filtering query at all. For example, you choose all product names, it is the same as if you didnt filter according to product names at all.