January 29, 2014 at 3:22 pm
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?
January 30, 2014 at 2:06 pm
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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply