2nd Parameter default to 1st parameters value

[JSMITH242B]

Hi Group,
I have a set of parameters I'm using for my report.
Both parameters are based on the same dataset.

What the user wants is when the user selects an item from parameter one, they want to default the 2nd parameter to this same item. Is this possible?

I tried using this as an expression: =Parameters!FirstParameter.Value for the Default value of the 2nd parameter, but this does not work.

Any help much appreciated.

 

[Catadmin]

The way I populated a second parameter with a default was to create 2 datasets, one for each parameter, and had the second dataset set up with an IF..ELSE clause that fed in the first parameter's value and set an internal variable to the first parameter's value.

At that point, you just tell the 2nd param to use the variable in the second dataset as it's default. It should work easier for you than it did for me because I was setting a specific default that was different than the first param.



Catadmin - MCDBA, MCSA
"The only stupid question is the one that *wasn't* asked.