Hi guys,
i have some report parameters that are dropdowns, and i would like to use whatever is selected in them to filter subsequent dropdowns.
I know that the report designer automatically makes parameters dependant on each other, but that has been stripped out of the rdl, i need to replace it with more targeted filtering.
So assuming that parameter A and parameter B get their values from a dataset, how can i filter parameter B's contents based on parameter A I am quite happy to tweak the rdl if that is what is required.
Thanks,
sluggy
Filter parameter based on prior parameter
hassssan
RedBeard
Not sure if I've got the best answer - but I have one just the same. :D
I use stored proc's for my datasets - procA returns values for parameter A and procB for parameter B. ProcB has a parameter supplied by Parameter!A.value, returning the expected, related dat. In the rdl's dataset area - I made sure I added a query parameter attribute for the procB parameter and it equals the Parameter!A.value.
HTH,
Joe
Marcelo Guerra - MSFT
If you think it's that one guy...you might be right...
Hit me up Adam - we have catching up to do.
Tejas Shah
yeah that is real cool joe,
even i came across this a number of times and i guess the best approach is as u said to adding a query parameter for a specific sproc.
more important is to have diff dataset for each sproc
so that is easy to append anything
regards,
www.snktheone.com