Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Standard drilldown feature for SQL Server Reports 2005 (SSRS)

Posted on 2011-02-12
3
Medium Priority
?
483 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 1000 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 1000 total points
ID: 34882909
0
 

Author Closing Comment

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

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

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

I have a large data set and a SSIS package. How can I load this file in multi threading?
An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
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
Suggested Courses

579 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