question

AshwinShyam-3607 avatar image
0 Votes"
AshwinShyam-3607 asked AshwinShyam-3607 commented

Parameter not being refreshed.

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
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

ZoeHui-MSFT avatar image
0 Votes"
ZoeHui-MSFT answered AshwinShyam-3607 commented

Hi @AshwinShyam-3607,

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










· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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.

0 Votes 0 ·

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


0 Votes 0 ·

@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??

0 Votes 0 ·