Enable reporting services drill down
- Martin Gudme Søndergaard
Introduction
Reporting Services drilldown is a link between two reports, for more information about one of the items in the report. Reporting Services drill down is implemented in the reports with a hyperlink from one report to another report. The hyperlink is placed in one of the columns in the report and when clicking the hyperlink a new report is displayed with more information about the clicked item. In CapaInstaller it is possible to drill down with a computer, user, device, software, update or package.
Â
When a report with drilldown support is displayed, a number of drilldown Reports is selectable in a drop down box. The available drilldown reports is located in the database and are deployed when enabling drilldown for a Reporting Services report.
Step | Action |
1 | Click on File. |
2 | Click on Deploy to reporting services or Deploy predefined reports to reporting services. |
3 | If you want to enable drill down, check the checkbox |
| 4 | If drilldown is enabled, you can choose whether you want to export the drilldown reports. If you choose not to export, then drill down reports have to be on the Reporting Services server, or the drilldown will not be working. |
| 5 | Enable Export drilldown as a Service, to be able in the drilldown reports to filter on Departments. |
6 | The drilldown reports it automatically deployed to folder /CMS/Drill down on the Reporting Services |
