SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
Register Now and get your question answered!
Save Password
Forgot your Password?

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

Constraint Violating Yak Guru

325 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  
 New 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.05 seconds. Powered By: Snitz Forums 2000