Reblogged from Marlon Ribunal's Note On SQL Server:

• 
• 

One of the most common business requirements for SQL Server Reporting Services is that an SSRS Report should be dynamic. Dynamic in a sense that the report consumer can query the report in a variety of ways. In this post, I will demonstrate how you can add a parameter value "ALL" to return all of the desired result.

I have four parameters in this report; all of them are…

Read more… 99 more words

Adding "ALL" Parameter in SSRS (Reblog)