x

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!!!
more ▼

asked Jan 11, 2012 at 07:35 AM in Default

jhowe gravatar image

jhowe
1.1k 54 58 61

(comments are locked)
10|1200 characters needed characters left

1 answer: sort newest

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
more ▼

answered Jan 11, 2012 at 07:46 AM

WilliamD gravatar image

WilliamD
25.9k 17 19 41

ok thanks i'll have a look!
Jan 12, 2012 at 05:59 AM jhowe
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1853
x561
x113

asked: Jan 11, 2012 at 07:35 AM

Seen: 1553 times

Last Updated: Jan 11, 2012 at 07:42 AM