2

I want the parameter value to be checked automatically in the second dropdown based on the selection of first parameter value.

For e.g In the below image i am selecting the Finops in the first dropdown so in second dropdown it should checked automatically.

Can anyone please guide?

enter image description here

Jonnus
  • 2,988
  • 2
  • 24
  • 33
Rajashri
  • 59
  • 1
  • 5

1 Answers1

1

What you want to create is also known as cascaded parameters in SSRS world.

Set the default parameter to whatever value you want to see like below:

enter image description here

Just make sure whatever value you are adding as default value is also present in the set of Available Values.

SouravA
  • 5,147
  • 2
  • 24
  • 49