SSRS default parameter

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Business Intelligence » SSRS default parameter

SSRS default parameter

Rate Topic

Display Mode

Topic Options

Author

Message

kalyav21

Posted Friday, August 24, 2012 3:44 AM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, November 21, 2012 5:24 AM
Points: 13, Visits: 26

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

Koen Verbeeck

Posted Monday, August 27, 2012 1:45 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Today @ 2:14 PM
Points: 9,370, Visits: 6,468

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

kalyav21

Posted Monday, August 27, 2012 2:25 AM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, November 21, 2012 5:24 AM
Points: 13, Visits: 26

Yes, I used the query (like)
Select Max(LoadMonth)
From Table
Where ClientName=@ClientName

Post #1350253

Tim Paulsen

Posted Tuesday, August 28, 2012 10:06 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, April 29, 2013 11:19 AM
Points: 6, Visits: 33

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

mtillman-921105

Posted Tuesday, August 28, 2012 10:14 AM

Right there with Babe

Group: General Forum Members
Last Login: Friday, May 10, 2013 11:54 AM
Points: 749, Visits: 3,767

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

kalyav21

Posted Tuesday, August 28, 2012 10:33 AM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, November 21, 2012 5:24 AM
Points: 13, Visits: 26

Yes, it is already to set to "Always refresh" only. Thank you.

Post #1351103

kalyav21

Posted Tuesday, August 28, 2012 10:45 AM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, November 21, 2012 5:24 AM
Points: 13, Visits: 26

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

Tim Paulsen

Posted Tuesday, August 28, 2012 11:16 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, April 29, 2013 11:19 AM
Points: 6, Visits: 33

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

kalyav21

Posted Friday, August 31, 2012 4:57 AM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, November 21, 2012 5:24 AM
Points: 13, Visits: 26

Thank you Tim. It's really helpful.

Post #1352703

« Prev Topic | Next Topic »

Permissions