Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Resetting Parameter Default Value Expand / Collapse
Author
Message
Posted Friday, November 1, 2013 2:52 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, February 5, 2014 1:55 PM
Points: 5, Visits: 18
I have two parameters, ParameterA and ParameterB.

I want to set the default value of ParameterB based upon the selected value of ParameterA.

Step 1
The first time a value is selected for ParameterA, the default value for ParameterB is set based on the value of ParameterA. This works fine.

Step 2
The next time a value is selected for ParameterA, I want the default value of ParameterB to be reset to a new value based on the new value of ParameterA. This is not working.

First, is it even possible to get Step 2 to work?

Second, if it is possible to get Step 2 to work, how can it be done?

Thank you.
Post #1510814
Posted Tuesday, November 5, 2013 6:40 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, July 24, 2014 1:50 PM
Points: 532, Visits: 448
Does it work if you deploy the report to the report server?
Post #1511468
Posted Wednesday, November 6, 2013 5:18 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 4:58 AM
Points: 236, Visits: 2,659
You need to make sure the parameter is set to refresh on change... Go to the parameter properties... Then to the advanced window... make sure the Refresh data when parameter changes is set appropriately.
Post #1511818
Posted Friday, November 8, 2013 1:43 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, July 25, 2014 1:36 AM
Points: 44, Visits: 207
Are ParameterA and ParameterB Multivalue DropDownList?
In this case the behaviour of DefaultValue is quite complicted.

Let me know and i'll try to explain....
Post #1512560
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse