Select All as default value for Multivalue parameter

sql-server visual-studio-2008 reporting-services parameters
iljitj picture iljitj · Mar 24, 2010 · Viewed 113.5k times · Source

I'm building a report in Visual Studio 2008 with a lot of multivalue parameters and it's working great, but I would like to have have the "(Select all)" option as the default value when the report is opened.

Is there some kind of expression or SQL code I can use to make this happen? Or do I need to choose "(Select all)" every time, in every parameter, each time I want to run the report?

Answer

JC Ford picture JC Ford · Mar 30, 2010

Try setting the parameters' "default value" to use the same query as the "available values". In effect it provides every single "available value" as a "default value" and the "Select All" option is automatically checked.

Related questions

SSRS the definition of the report is invalid

How can I resolve the below error message that I receive when I try to deploy my report to our our Reporting Server using BIDS? Message: Error : The definition of the report '/OrderAnalysis' is invalid. Report Element: <Report …

Read More
How can I automate the "generate scripts" task in SQL Server Management Studio 2008?

I'd like to automate the script generation in SQL Server Management Studio 2008. Right now what I do is : Right click on my database, Tasks, "Generate Scripts..." manually select all the export options I need, and hit select all on the "…

Read More
What are the limitations to SQL Server Compact? (Or - how does one choose a database to use on MS platforms?)

The application I want to build using MS Visual C# Express (I'm willing to upgrade to Standard if that becomes required) that needs a database. I was all psyched about the SQL Server Compact - because I don't want the …

Read More