Solved

Standard drilldown feature for SQL Server Reports 2005 (SSRS)

Posted on 2011-02-12
3
463 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

632 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