February 18, 2009 at 2:23 pm
Is there a was to filter report parameters based on another filter? I understand the concept of cascading parameters where param2 gets filtered by param1. What I need ( and I think is a pretty normal requirement) is to be able to start with either parameter (1 or 2) and filter the other one accordingly. So if I have 5 params, I want to be able to start with any of them and have all others update accordingly instead of being forced down a hierarchy like cascading parameters does.
Thanks for the help.
February 18, 2009 at 2:49 pm
I don't think that there is a way to do this natively in SSRS. When I have needed that I have usually done an aspx page that has the parameters and I call the report from there.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
March 11, 2009 at 8:30 am
Thanks for the response. I assume you are talking about doing this via a query string. Unfortunately, i can't so this because of query string size limitations. I pass way too many parameters. I was hoping there was a way to pass a dataset from a custom assembly that cuold accept parameters and filter accordingly.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply