SSRS Multi-Value Parameter Performance Issue

Josh,

So you've built a report off a query that uses a multi-value parameter and you've defaulted the parameter to use every option from a dataset.  This works fine for a few values, but when the multi-value parameter contains hundreds, the query is dreadfully slow!

The solution is to add a default value to ignore your parameter in the query...

Passing Multi-Valued Parameters to a Linked Report

Dear Josh,

This one has been bothering you for sometime and you finally figured it a couple weeks ago.  The scenario is you have a summary report, like a map, and a detail report.  You want to allow a user to filter certain things on the summary and be able to drill down into the detail of an element.

The issue is if there are parameters with multiple values selected, how do you pass all of the selected values to the linked report?