Standard drilldown feature for SQL Server Reports 2005 (SSRS)

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.
jbaird123Asked:
Who is Participating?
 
dbaSQLConnect With a Mentor Commented:
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
 
jbaird123Author Commented:
Thank you very much!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.