# Enable reporting services drill down

> Enable drill-down, the link from one report to another with more detail about an item.

Source: https://docs.capaone.com/capainstaller/the-capainstaller-console/reporting-and-queries/how-to-use-reporting/enable-reporting-services-drill-down/  
Product: CapaInstaller — a separate CapaSystems product; do not apply this page to any other.

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*.   ![](/attachments/capainstaller/63bdc887-013e-4960-9638-4ba18ef6d808.png)   Or   ![](/attachments/capainstaller/c4f3ca85-ee7c-4310-8281-d6166103ea47.png) |
| 3        | If you want to enable drill down, check the checkbox ![](/attachments/capainstaller/84a53685-5404-466d-8eeb-121240059889.webp)                                                                                                                         |
| 4        | If drilldown is enabled, you can choose whether you want to export the drilldown reports. <br/> 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                                                                                                                                                |

## Related

- [Reporting services drill down](/capainstaller/the-capainstaller-console/reporting-and-queries/what-is-reporting/reporting-services-drill-down/) - What drill down is and how it links reports together.
- [Deploy to reporting services](/capainstaller/the-capainstaller-console/reporting-and-queries/how-to-use-reporting/deploy-to-reporting-services/)
- [Deploy predefined reports to reporting services](/capainstaller/the-capainstaller-console/reporting-and-queries/how-to-use-reporting/deploy-predefined-reports-to-reporting-services/)