x
login about faq Site discussion (meta-askssc)

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 '12 at 07:35 AM in Default

jhowe gravatar image

jhowe
919 29 42 46

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

1 answer: sort oldest

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 '12 at 07:46 AM

WilliamD gravatar image

WilliamD
25.3k 16 18 41

ok thanks i'll have a look!

Jan 12 '12 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



Facebook logo Follow Ask SSC on Facebook
Find Ask SSC on Google+
linkedin logo Find us on LinkedIn

Topics:

x1601
x486
x95

asked: Jan 11 '12 at 07:35 AM

Seen: 772 times

Last Updated: Jan 11 '12 at 07:42 AM

Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved. If you have any queries, please contact the site administrators.
Ask SQL Server Central is a community service provided by Red Gate.