Parameter not being refreshed.

Question

Parameter not being refreshed.

Ashwin Shyam 1

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.

0 comments

1 answer

Your answer

Answer 1

ZoeHui-MSFT 41,551

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

Ashwin Shyam 1 Reputation point

2021-02-23T11:17:54.827+00:00

Hello @ZoeHui-MSFT
Yes, you're right, I am talking about cascading parameters.
The problem is my Y parameter is a text box and its advanced property is set to always refreshed.

Now, when I set the value of X parameter for the first time, Y parameter gets loaded accordingly, but when I set the value of X parameter for the 2nd time (or 3rd or nth time), the value of Y parameter doesn't get refreshed. It remains the same. I want the Y parameter to get refreshed with the value accordingly every time X Parameter is changed.
ZoeHui-MSFT 41,551 Reputation points

2021-02-24T02:29:44.237+00:00

Sorry for my misunderstand. As the Y parameter has set as always refresh, it should refresh when the X change. Did you specified available values base on the parent parameter? If not, the parameter will not refresh when the value of the parent parameter has changed. We should specify available values and defaults values for child parameters. And the Y parameter should be a dropdown box instead of textbox. Details refer:add-cascading-parameters-to-a-report-report-builder-and-ssrs
Ashwin Shyam 1 Reputation point

2021-04-05T04:58:08.22+00:00

@ZoeHui-MSFT Yes, the Y parameter has been set as always refresh and default value has been set to "Get Values from a Query". The Issue with setting Available values to "Get Values from query" is that by doing this the text box gets converted to a drop down. I want the user to be able to either go with the default value or enter a custom value which he wants, which can't be done with a drop down. So as a result a text box is essential. Is there any way by which I can load the default value of Y Parameter every time the value of X parameter is changed??

Share via

Parameter not being refreshed.

1 answer

Your answer