October 3, 2006 at 11:31 am
I'm having a problem. I have reports which are in production and have the multi-value parameter checked in the report parameter. However the 'Select All' option does not appear. I know it used to...at least I don't think I've lost my mind. Even the online help backs me up with 'When you define an available values list for a multivalued parameter, Reporting Services automatically provides a Select All option on the report toolbar drop-down list. ' I have checked my test and production server and none of the reports have it anymore. I even tried to create a brand new report and selected the multi-value and the 'Select All' does not appear. In all of these reports, you can actually select multiple values. It's just the 'Select All' is gone. Can anyone provide direction as to where to continue digging on this problem.
Thanks
October 3, 2006 at 11:50 am
never mind...helps if you read a bit farther ....guess I wasn't aware they had a applied the service pack
In a SQL Server 2005 Reporting Services report, if you created a valid values list for a multivalue report parameter, a Select All option is automatically added to the available values list. If you upgrade to SQL Server 2005 Service Pack 1 (SP1), the Select All option is no longer automatically created because the option affects performance when used with a multidimensional data source.
You can add an All member as a parameter value by modifying the query that supplies available values. Change the query for the dataset that provides available values to include a literal "All" member, change the query for the dataset for the report data to test for the parameter value or the All member, and set All as the default value for the report parameter. For more information, see Working with Parameters in Reporting Services.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply