Hey All, I wish to use cascading parameters but with Filters instead of the regular usage inside the query string. That means I wish to bring the full data set (since I am using snapshot), then let the user filter the data according parameters. Since some parameters bring a long list of data, I would like to use the cascading option. For some reason I cannot make it happen; also - all explanation/toturials about cascading parameters are using parameters inside the query string itself (that works fine for me but would not suite a snapshot). Anyone knows how the above can be achieved? Thanks, Iris--

In your first set of parameters, in the where clause, have a field = @paramater2, and so on... This will "feed" each of them. Here's a helpful site: http://msdn.microsoft.com/en-us/library/aa337498.aspx

Hi Iris, From my testing, I’m afraid we can only use cascading parameters by specify the high-level parameter inside the query string in Reporting Services 2008, while the feature of using Filters for cascading parameters is supported in Reporting Services 2008R2. However, if you haven’t planned to upgrade Reporting Services, I would suggest you to submit a feedback at https://connect.microsoft.com/sql. If the service requests frequently, we may include it in the next service pack. We appreciate your understanding. If you have any question, please feel free to ask. Thanks, Tony ChainPlease remember to mark the replies as answers if they help and unmark them if they provide no help

Thanks Tony. I was afraid it isn't doable... I guess my client will have to wait to our upgrade. Iris--