rmm2001
asked on
SSRS FIlter Parameters on previous selected parameters
Hi All -
I have 4 parameters for my SSRS 2008 report: A, B, C, D. A and B are independent of each other.
But for whatever A and B are selected - I want them to help filter out C.
So .. select * from tableC where column1 IN (@A) AND column2 IN (@B).
And then parameter D is dependent on parameter C
so .. select * from tableD where column1 IN (@C)
Is the possible in SSRS or do all of my parameters need to be loaded pre-render?
Thanks!
I have 4 parameters for my SSRS 2008 report: A, B, C, D. A and B are independent of each other.
But for whatever A and B are selected - I want them to help filter out C.
So .. select * from tableC where column1 IN (@A) AND column2 IN (@B).
And then parameter D is dependent on parameter C
so .. select * from tableD where column1 IN (@C)
Is the possible in SSRS or do all of my parameters need to be loaded pre-render?
Thanks!
ASKER
That's how it's set up right now and it's not filtering based off of the parameter I select. It seems like it's loading everything at once for the parameter lists and not posting back after I select one option. Is there a way to make it operate where it posts back after every selection so the lists refresh?
Thanks for replying!
Thanks for replying!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
This seems to be working now. Odd that I had to recreate everything like that though.
Thanks!
Thanks!
Untitled.png