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

avatar image

jhowe
1.1k 56 60 66

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

1 answer: sort voted first

You can reference one dataset using the parameter from a previous parameter entry.

This tutorial on MSDN seems a little complicated at first, but describes the scenario quite well.

more ▼

answered Jan 11, 2012 at 07:46 AM

avatar image

WilliamD
26.2k 18 34 48

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:

x2091
x660
x127

asked: Jan 11, 2012 at 07:35 AM

Seen: 1927 times

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

Copyright 2016 Redgate Software. Privacy Policy