Standard drilldown feature for SQL Server Reports 2005 (SSRS)
Posted on 2011-02-12
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.