How to work with cascading parameters ?

ReportServer (EN)
1

Hi,

I would like to know how we could work with parameters which are dependent on each other. For example state and district.
State and Districts are my Jasper Report parameters (data source params in RS):

Say State 1 has districts 11,12,13 and 14…and State 2 has districts 21,22,23 and 24.

As soon as I select State 1 ..Districts 11,12,13 and 14 should be auto selected. Basically I’m looking for the equivalent of cascading parameters from jasper server.

Is this possible in RS? If so..please guide me..

Secondly, I’d like to know what “Depends On” is used for in the Parameters options..My original question (cascading params) got me here..and when i tried adding a param to “depends on”…i noticed that the dependant param (district) gets refreshed when a selection change occurs on the main param (state)

Help would be appreciated.

Thanks and regards,

TZM

2

Hi, you might be looking for:

https://reportserver.net/en/guides/admin/chapters/parameter-cascading/

it states:
By using cascading parameters you can use parameters within parameters and thus nest parameters. Source parameters can here be any parameters. At present, only the data source parameter supports the configuration by means of depending parameters. To do this, on the general configuration page of the data source parameter set the parameters on which the data source parameter will depend. In the following you can use them in the data source configuration as describe below.

Also check: https://reportserver.net/en/guides/admin/chapters/using-parameters/ for general instructions using parameters.

hope that helps

Jan