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

sql server 2008 cascading paramters Expand / Collapse
Author
Message
Posted Wednesday, January 29, 2014 3:22 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 3:46 PM
Points: 295, Visits: 335
When looking at an existing SSRS 2008 r2 report, I am told that cascading parameters are used in this particular report. I am trying to determine how the parameters are 'wired together' so that the parameters are cascading. When I look at the parameters associated with the datasets used in this report, I see that some of the datasets refer to other parameters not directly associated with that particular dataset.

Thus is this a way to tell what are the cascading parameters? If so, are other there other ways to tell what are the cascading parameters? If not, can you tell me how to tell why the cascading parameters are for a particulart report?
Post #1536120
Posted Thursday, January 30, 2014 2:06 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, April 08, 2014 10:46 AM
Points: 123, Visits: 234
Cascading parameters provide a way to reduce the number of user choices in the parameter drop down box.

Parameter 1 is created as a base. Then it is used as part of the filter in the underlying query for Parameter 2.

You can find a more detailed explanation at http://technet.microsoft.com/en-us/library/aa337498(v=sql.105).aspx
Post #1536551
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse