You can drill up and drill down within a report that is run from Reporting Center. Reports run from Reporting Center appear in Report Viewer.
In lists and crosstabs, hyperlinks identify drillable items. In charts, the pointer changes to a hand when you pause the pointer over a drillable item, and a tooltip indicates what you are drilling on. For example, a column chart shows revenue by product line by year. You can drill on a single axis, such as product line or year. You can also drill on both axes, such as Camping Equipment and 2005. In this case, you are drilling on the intersection of Camping Equipment and 2005.
If groups of data items from different queries are linked, when you drill up or drill down in one query, the data item also drills up or drills down in the linked queries. For more information about how to link groups of data items, see the Report Studio Professional Authoring User Guide.
After you drill up or drill down, you can save the report as a report view for later viewing. For more information, see Create a Report View.
The drill-up and drill-down functionality is available only when you use dimensionally structured data and view the report in HTML format. You can drill only on members in a level.
By default, the drill-up and drill-down functionality is enabled.
Run the report in Reporting Center and view it in Report Viewer.
Note: Alternatively, you can open a Query Studio report.
Right-click the report item you want to drill on and click Drill Up or Drill Down.
