Alex Rivera | Logout

Select All as default value for Multivalue parameter

Asked 2010-03-24T15:23:16.303
63

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?

sql-server visual-studio-2008 reporting-services parameters
Edit
Report

1 Answer

111

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.

answered 2010-03-30T18:46:33.023

Your Answer