Pages

Tuesday, May 31, 2011

SSRS Empty Parameter

I stumbled upon this at work and wanted to share this to everyone. In SSRS create a parameter and give it Multi-Value. Keep the Default and Shared Values Null. When you are viewing the report you can copy and paste or hand-enter in a value to that parameter.

If you use a stored procedure parameter you can pass in multiple values with a ",". Try it out!

No comments:

Post a Comment