You are not logged in.
Pages: 1
Is it possible to pass the value of selected parameter to another parameter in the same report?
Example : If a report has 2 Data source parameters - country and state. If I select country = 'US' , the parameter value would additionally get passed to state report parameter so that it can append an extra condition to get states where country is 'US'. This way, in the list drop down the user gets to select states of US and not of other countries.
Thanks
Aditi
Offline
Hi Aditi,
yes, this is possible with datasource parameters. These are called cascading parameters.
Usually you would write your parameter2 query as something to the extend of:
Select key_col, val_col from mytable where some_col = $P{param1}
Also, please note this: Don't forget to add myValue as a dependent parameter: "Parameter properties" -> "Depends on"
Check here:
https://forum.reportserver.net/viewtopic.php?id=1344
and here:
https://reportserver.net/en/guides/admi … cascading/
Regards,
Eduardo
Offline
That helps. Thanks so much !
Offline
Hi,
Just to extend this scenario of Cascading prompt, I have a requirement where User can select multiple values. Would you be able to help how this could be achieved as it seems like ReportServer only Supports Single Selection for Cascading Prompts.
Thanks
Offline
Hi michigunesh,
if you need multiple values, you can write a different query:
instead of
Select key_col, val_col from mytable where some_col = $P{param1}
you could write:
Select key_col, val_col from mytable where some_col = $X{IN, column, param1}
or
Select key_col, val_col from mytable where some_col = $X{NOTIN, column, param1}
More information on parameters:
https://reportserver.net/en/guides/admi … arameters/
Regards,
Eduardo
Offline
Thanks a lot, that helped.
Offline
Pages: 1