August 24, 2012 at 3:44 am
Hi,
I'm trying to develop a new rdl with 2 parameter, both are with drop down values. One parameter is ClientName (say) A,B,C and other parameter is YearMonth which defaults to Max Loadmonth. Which has values like 201201,201202,201203.
I'm previewing the report -> selected ClientName A, for which MaxLoadmonth is 201202, its selected automatically when I select the clientname as it is default. I got results
Next, I'm selecting ClientName B, for which MaxLaodMonth is 201204(this is higher than the loadmonth of my first selection).
Here, the default for the 2nd selection is not changing automatically when i select the clientname, because the loadmonth range is higher than 1st selection.
Any clientname with MaxLoadmonth is less than the previous selection are populating default values automatically.
Please advise.
August 27, 2012 at 1:45 am
How did you set the default for MaxLoadMonth? Did you use a query?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 27, 2012 at 2:25 am
Yes, I used the query (like)
Select Max(LoadMonth)
From Table
Where ClientName=@ClientName
August 28, 2012 at 10:06 am
Did you try setting the advanced property of the parameter to "Always refresh"? Sometimes the "Automatically determine when to refresh" decides not to refresh the default value for the second dropdown.
August 28, 2012 at 10:14 am
If I'm understanding correctly, you want to use cascading parameters since you want the value of one parameter's available options dependent upon the value of the first parameter (in this case, the client name). If so, you should look into cascading parameters.
The greatest enemy of knowledge is not ignorance, it is the illusion of knowledge. - Stephen Hawking
August 28, 2012 at 10:33 am
Yes, it is already to set to "Always refresh" only. Thank you.
August 28, 2012 at 10:45 am
Even in cascading parameter too, the value is not getting refreshed when the 2nd parameter value is higher than the first selection. E.g., for first selection MaxLoadmonth is 201202 and for second selection MaxLoadmonth is 201204.
August 28, 2012 at 11:16 am
Check out this link:
http://www.bp-msbi.com/2011/04/ssrs-cascading-parameters-refresh-solved/. Apparently not refreshing the default value on cascading parameters is by design. The above link shows a work around to this behavior.
August 31, 2012 at 4:57 am
Thank you Tim. It's really helpful.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply