Select All as default value for multiple values parameter SSRS

views:

499

answers:

+1 Q:

Select All as default value for multiple values parameter SSRS

Hi there

I'm building a report in VS08 with a lot of multiple values parameters and it's working great, but I would like to have have the "(Select all)" option as 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?

Thanks anyway!

/iljitj

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.

JC 2010-03-30 18:46:33

Thanks a ton. Only thing to add is; if the query you are using for "available values" returns any null values, you can't set the default value to "(select all"), probably because the multivalue function doesn't allow nulls. Anyway thanks a lot for the answer.

iljitj 2010-03-31 09:57:28

its a simple work around. Thanks a lot

sampath 2010-05-28 17:03:47

Does not work if you have nulls.

You can get around this by modifying your select statement to plop something into nulls:

phonenumber = CASE WHEN (isnull(phonenumber, '')='') THEN '(blank)' ELSE phonenumber END

E_8 2010-06-30 21:21:05

ansaurus

tags:

views:

answers:

Select All as default value for multiple values parameter SSRS

related questions