Adding a Dropdown Parameter List to a Report

It's easy to build a a parameterized Reporting Services report by just including something like 'where lastname = @lastname', but what happens when the lookup value is less memorable? We'll show you how to build a lookup list based on a second query and how to link it to the original query. It's fast, easy, and absolutely worth doing to make it easier for your end users.

Andy Warren is a software trainer focusing on SQL Server, a member of the PASS Board of Directors, and a principal in this site - SQLShare.com.

surya on 4/15/2010

this is a longer process to see this Vedio Make it to Simple

Gary Fairchild on 4/15/2010

This demo is for SQL 2008, not SQL 2005 or SQL 2000. I feel that needs to be pointed out.

Sean on 4/15/2010

Thank you for the training. It would be nice to have something that shows which classes I have watched so i don't watch the same on twice.

Anil Inampudi on 4/15/2010

very gud one

Jack Hellmuth on 4/15/2010

Can you have one parameter's values depend on another parameter's previously selected value?

Stephen Anslow on 4/15/2010

Having issues with multi-select dropdown passing values to cascading multi-select dropdown, especially when attempting to set up a subscription. Any chance a video helping us out with kind of problem could be made?

Dan Ascher on 4/15/2010

very cool

dennis on 4/15/2010

This was very useful for me.

James Lim on 4/15/2010

This was a helpful and useful video since I don't setup reports that often.

Rhonda Roscovius on 4/15/2010

Can you show me how to create a multi-select dropdown parameter list?

Ameena on 4/15/2010

How you display the ALl in the drop down list of report?

glyn on 4/16/2010

Unbelievable! I came into work this morning to find out how to do 'parameterised drop down lists' and this email was in my inbox waiting for me... so there is someone out there looking out for me! Thank you for this it was exactly what I needed. Glyn@thevirtualzone.co.uk

sudipta on 4/16/2010

Effective !

Gerard Crawford on 4/16/2010

Very Helpfull, would like to see more on Reporting Services

Cosmin Tornea on 4/16/2010

ok

Munna Bhai on 4/18/2010

This is really helpful. Thanks for sharing.

BABDE9F59F on 4/19/2010

It would be helpful if he's talked a bit slower.

ricardoacaraujo@hotmail.com on 4/20/2010

Bom

ML Stephens on 5/6/2010

ok now i need to use it in my report build

A7E76C188C on 5/7/2010

The screen display fonts appear too small to read.

Rudy on 5/25/2010

great video

Steve Culshaw on 5/29/2010

Another great video

Charlie Bruno on 8/12/2010

The videos are excellent tools to learn various pieces of functionality. Your organization is doing a first rate job in educating the SQL Server community. I appreciate it.

Jeremy Callahan on 6/14/2011

Very nice

David Branscome on 4/27/2012

Thanks Again, I've been off RS for years and this helps!!

David Branscome on 5/2/2012

Again Thanks

Leon on 1/19/2013

Usefull, but a bit quickly