SSRS Multi-Value Prompt Default

Question

SSRS Multi-Value Prompt Default

bob_levine

SSC Veteran

Points: 243
More actions
August 4, 2010 at 3:11 pm

#225123

I have a multi-value prompt in my SSRS report. I need the prompt default to include all values and to read "ALL". How do I do this?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Don Shields-368041 Ten Centuries Points: 1189 More actions · Answer 1

You need to create a separate datasource that returns a datatable filled with the default values you want selected. You can't make it select the "All" but you can get it to check the boxes for all the items in the list.

For instance if the Datasource for the Multi-value parameter returns possible values of

1

2

3

and you want those all checked, then create a second datasource that returns the same values and set the default value for the paramater to the second datasource. I've done this many, many times.

Don Shields

weitzera Hall of Fame Points: 3442 More actions · Answer 2

You can also use the same data source for both the default and available values.

Dan Guzman - Not the MVP (7/22/2010)
All questions have to be prefaced by Server version and 'according to MS Docs' or 'my own personal opinion based on how much detail I felt like digging into at the time.'

Don Shields-368041 Ten Centuries Points: 1189 More actions · Answer 3

That is true. A separate data source is needed when you you want something differnt than all values to be checked as defaults.

Don