Dynamic report parameters

  • 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.

  • 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.

  • 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