Solved

Standard drilldown feature for SQL Server Reports 2005 (SSRS)

Posted on 2011-02-12
3
440 Views
Last Modified: 2012-05-11
I am using SSRS 2005, and I am trying to figure out how to create a standard drilldown report.  I have a list of salespeople with aggregate data calculated for each one (# of leads, # of quotes, # of sales).  I would like the user to be able to click on any one sales person and have the grid expand to show the supporting detail underneath.  The supporting detail would have different columns than the aggregate grid (list of customer name, address, etc).

I cannot see any easy way to make this happen.  Can anyone help?  Examples or tutorials on how to do this sort of thing would be appreciated.

Thanks.
0
Comment
Question by:jbaird123
3 Comments
 
LVL 17

Accepted Solution

by:
dbaSQL earned 250 total points
Comment Utility
This is a wonderful tutorial about advanced the aggregation/filtering functions that are available in SSRS, to include the drill-down functionality that you are looking for.  
http://www.devx.com/dbzone/Article/37799/1954

0
 
LVL 21

Assisted Solution

by:huslayer
huslayer earned 250 total points
Comment Utility
0
 

Author Closing Comment

by:jbaird123
Comment Utility
Thank you very much!
0

Featured Post

Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

Join & Write a Comment

Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now