Deepak Puri
Though this paper was written for Reporting Services 2000, it explains how to use the Reporting Services "Drill-through" Action to launch a 2nd report from a cube-based chart report, to provide more details:
Microsoft SQL 2000 Technical Articles
Integrating Analysis Services with Reporting Services
Sean Boon
Microsoft Corporation
June 2004
Applies to:
Microsoft SQL Server 2000
Summary: Create a compelling solution for your customer that defines and manages great-looking Analysis Services reports, and quickly answers analytical questions to improve traditional reporting scenarios. (33 printed pages)
Download the associated ASandRSSamples.exe code sample.
...
Adding "Drill-through" Capability to a Report
The concept of "drill-through" can mean different things depending on the technology being used. For those familiar with Analysis Services, drill-through represents the ability to return the detail records that contribute to the value of a cell. For Reporting Services, "drill-through" is the capability to jump from one report to another report when the user selects an action-enabled object on the report.
...
Using the Reporting Services "Drill-through" Action
In the first example, we'll create a report action that is triggered when a user selects a bar on a chart. The report for this example is included in the file FoodmartDrillThrough.rdl. If you preview this report, you'll find that the report contains a chart that displays the sales for the selected product and time period for each city. If you select any of the bars that represent the sales of a city, a report action of type "drillthrough" is executed. This process opens the FoodmartDrilledTo report that displays how each promotion contributed to the overall sales of the selected product. The report parameters from the initial report are passed to the second report and are displayed at the top of the report for reference.
...