Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 sql server r2 cascading parameters
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Constraint Violating Yak Guru

332 Posts

Posted - 01/29/2014 :  17:20:31  Show Profile  Reply with Quote
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?

Very Important crosS Applying yaK Herder

52326 Posts

Posted - 01/30/2014 :  07:04:11  Show Profile  Reply with Quote
cascading parameters means parameters will be interdependent
you can find dependency by going inside parameter properties and seeing the dataset that it uses as the source. That dataset will have dependent parameters used for filtering its data. By traversing similarly you can get full list of parameters which are cascaded.

SQL Server MVP
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000