Forum Discussion

anmolmalviya05's avatar
anmolmalviya05
Icon for Super User rankSuper User
2 years ago

Parameters 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...
Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi, anmolmalviya05 

You can set default values for the parameters as shown below:

 

Parameter_OrderName is the dataset used to get the parameter OrderName.


When you run the report, it will default to select Select All:

 

 

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.