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!
LVL 7
rmm2001Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
iosifsConnect With a Mentor Commented:
Hy,

Delete parameter C an recreate it (by refreshing the dataset that contains parameter C).
If a parameter is dependent by other parameters then it should be created after those parameters.
0
 
Alpesh PatelAssistant ConsultantCommented:
yes you can do it at way.


Untitled.png
0
 
rmm2001Author Commented:
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!
0
 
rmm2001Author Commented:
This seems to be working now. Odd that I had to recreate everything like that though.

Thanks!
0
All Courses

From novice to tech pro — start learning today.