Optimize Reporting Services With a Filter Table

(Ben Taylor) For years we have wrestled with the need to pass n number of parameters to a database to be used as a filter in a query. The filtered result could be used for a report or even for screen presentation. Reporting Services, like all other reporting tools, is no exception to this problem. In this article I demonstrate a preferred solution and apply it to reporting services.