Dynamic updating of Parameters.

Hi I am using sql server reporting services 2000 and in a report I have more than 20 parameters of data type Boolean. I want another parameter drop down which have "select all" and "clear all" options. When user select “select all” option from the parameter list all 20 parameters value should be false.

I will be very thankful.

Regards,

Faisal Saleem

Hi Faisal,

try to use "cascading parameters" and "default values".

More info here:
http://msdn2.microsoft.com/en-us/library/ms170246.aspx

cheers

Markus

|||

Firstly cascading/dependent parameters only work when they are populated from a dataset that uses another parameter. This is not the case here as these are boolean parameters.

Secondly, default values are only applied when the report first loads. So once the user changes any of the parameters, default values are no longer considered and hence trying to use use default values with deperndent parameters will not work.

Cascading parameters are used to modify/effect the list of available values rather than the one that's actually selected.

Although at first is seems like this should be possible, I don't think it is.

Instead, can I suggest that you change the "select all" parameter to contain 3 values:

All

None

Custom

|||

Adam Tappis - IMGroup wrote:

Secondly, default values are only applied when the report first loads. So once the user changes any of the parameters, default values are no longer considered and hence trying to use use default values with deperndent parameters will not work.

Cascading parameters are used to modify/effect the list of available values rather than the one that's actually selected.

I just ran into this and it seems like a functional bug to me. It's great that cascading parameters can be used to alter drop-down options for subsequent parameters, but that's only part of the story. If subsequent parameter choices can be altered by a previous parameter selection, it is completely misleading not to do the same for setting defaults. The users find it very confusing.

Anyone know if this has been logged to Connect?

|||

GregsListAcct wrote:

Anyone know if this has been logged to Connect?

Just answered my own question. It is logged in Connect:

http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=268032

Microsoft is considering it "by design". :^(