The settings in the drill-through definition determine how users see the report results. For example, the users may see the reports in Report Viewer as an HTML Web page, or the reports may open in Query Studio, or PowerPlay Studio. If your users have PowerPlay Studio, then they may also see the default view of a PowerCube.
Reports can be opened as HTML pages, or as PDF, XML, CSV, or Excel formats. When you define a drill-through path, you can choose the output format. This can be useful if the expected use of the target report is something other than online viewing. If the report will be printed, output it as PDF; if it will be exported to Excel for further processing, output it as Excel or CSV, and so on.
If you define a drill-through path to a report that is created in PowerPlay Studio, or Query Studio, consumers can open the report in its studio instead of in Report Viewer. This can be useful if you expect a consumer to use the drill-through target report as the start of a query session to find more information.
Note: Drilling through to open the target in Report Studio is not supported for the Express Authoring mode. The Report Studio Professional authoring mode does not display data results.
