August 20, 2008 at 11:33 pm
I have a MSRS report which takes some parameter values to populate the report. The parameters are drop down controls which have multi select option enabled to have multiple values as a filter criteria. The parameter should have a default value pre-populated when the report 1st loads.
The problem is to have that default value as ‘Select All’, which automatically comes when we have a multi select option enabled. i.e. the 'Select All (as a word thats provided by MSRS tool) should be displayed on the report UI and also all the values in the drop down should be checked too.
How can I set this ‘Select All’ as a default value for the parameters?
Any suggestions??
August 21, 2008 at 12:23 am
Hello,
We have not found a way of doing that either, so we currently use a workaround similar to the one described here: http://www.themssforum.com/SVCS/MultiSelect-parameter-79674/
Regards,
John Marsh
www.sql.lu
SQL Server Luxembourg User Group
August 21, 2008 at 1:23 am
In that case i will 2 options to choose all the values. One that i will insert explicitly and one provided by the reporting tool.
Is there any way to have just one of the values.?
Please suggest
August 21, 2008 at 1:54 am
Hello Again,
Sorry, but as far as we know the built in "Select All" cannot be turned off. Please see this thread: https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=249227
(I must give credit to Andreas Gonsior for his help).
Regards,
John Marsh
www.sql.lu
SQL Server Luxembourg User Group
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply