Parameter not being refreshed.

Ashwin Shyam 1 Reputation point
2021-02-23T04:40:29.4+00:00

I have a parameter Y that is supposed to get refreshed according to the values set in parameter X which is fetching values from a query and is single select value.

My issue is that it is getting the values properly the first time but when the X parameter is changed the Y parameter remains same. I want the Y parameter to load the default value every time X parameter is changed and also the Y parameter to be editable so that the end user can change the values as desired if he wants to. Can anybody give some suggestions.

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,799 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 32,736 Reputation points
    2021-02-23T06:27:26.853+00:00

    Hi @Ashwin Shyam ,

    You are using Cascading Parameters, right?

    Based on your requirement, you may set the parameter properties of Y.

    when the X parameter is changed the Y parameter remains same

    You may set the Y property--Advanced--Never refresh.

    want the Y parameter to load the default value every time X parameter is changed

    When the Y parameter is set to never refresh, when you change the value of X, it won't change. And you can set the default value of the Y.

    Or you may not use the Cascading Parameters. Just add common Y parameter, make it independent.

    Regards，

    Zoe

    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
    Hot issues October