Microsoft SQL Server 2005 Reporting Services, 2nd Edition

4.2. An Interactive Table Report

Now that you have a taste of how the Report Wizard works and what it can do, let's try something a bit more complex. Let's create a table report that implements an interactive feature called drilldown. With the drilldown type of report, only the high-level, summary information is initially presented to the viewers. They can then click a special area of the report (in our case, that area is designated by a plus (+) sign) to reveal part of the lower-level, detail information. The viewers drill down through the summary to get to the detail.

4.2.1. The Customer-Invoice Report

Features Highlighted

• Using a shared data source

• Linking tables in the Graphical Query Designer

• Assigning columns for page breaks and grouping ...