Solved

Standard drilldown feature for SQL Server Reports 2005 (SSRS)

Posted on 2011-02-12
3
453 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
ID: 34880406
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:Jason Yousef, MS
Jason Yousef, MS earned 250 total points
ID: 34882909
0
 

Author Closing Comment

by:jbaird123
ID: 34910203
Thank you very much!
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

773 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