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

SSRS default parameter Expand / Collapse
Author
Message
Posted Friday, August 24, 2012 3:44 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, August 13, 2013 7:57 AM
Points: 14, Visits: 33
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.
Post #1349543
Posted Monday, August 27, 2012 1:45 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:29 AM
Points: 12,206, Visits: 9,168
How did you set the default for MaxLoadMonth? Did you use a query?



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1350240
Posted Monday, August 27, 2012 2:25 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, August 13, 2013 7:57 AM
Points: 14, Visits: 33
Yes, I used the query (like)
Select Max(LoadMonth)
From Table
Where ClientName=@ClientName
Post #1350253
Posted Tuesday, August 28, 2012 10:06 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, April 11, 2014 2:15 PM
Points: 6, Visits: 38
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.
Post #1351074
Posted Tuesday, August 28, 2012 10:14 AM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Tuesday, February 25, 2014 8:59 AM
Points: 754, Visits: 3,813
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
Post #1351084
Posted Tuesday, August 28, 2012 10:33 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, August 13, 2013 7:57 AM
Points: 14, Visits: 33
Yes, it is already to set to "Always refresh" only. Thank you.
Post #1351103
Posted Tuesday, August 28, 2012 10:45 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, August 13, 2013 7:57 AM
Points: 14, Visits: 33
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.
Post #1351112
Posted Tuesday, August 28, 2012 11:16 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, April 11, 2014 2:15 PM
Points: 6, Visits: 38
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.
Post #1351135
Posted Friday, August 31, 2012 4:57 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, August 13, 2013 7:57 AM
Points: 14, Visits: 33
Thank you Tim. It's really helpful.
Post #1352703
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse