question

jhowe avatar image
jhowe asked

cascading report parameter drop down ssrs

Hi all, I'm trying to figure out how to do a cascading drop down in ssrs. I know that ssrs doesn't really support this very easily but i'm sure there must be a workaround... For example : --- All teams/users --- Red Orange Blue Then if they select a team --- All users for team selected --- Kevin Mike John Any suggestions would be greatly appreciated!!!
sql-server-2008ssrsssrs-2008
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
WilliamD avatar image
WilliamD answered
You can reference one dataset using the parameter from a previous parameter entry. [This tutorial on MSDN][1] seems a little complicated at first, but describes the scenario quite well. [1]: http://msdn.microsoft.com/en-us/library/aa337498.aspx
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

jhowe avatar image jhowe commented ·
ok thanks i'll have a look!
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.