Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jassie
Constraint Violating Yak Guru
332 Posts |
 Posted - 2014-01-29 : 17:20:31
|
| 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? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2014-01-30 : 07:04:11
|
| cascading parameters means parameters will be interdependentyou 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 MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
|
|
|
sql server r2 cascading parameters