SSRS - (Hierarchy|Drill Down)

Ssrs Report Designer Pane


A hierarchy is defined within the group functionality.


Drilldown functionality is only available when a published report is viewed in a browser or exported to a format such as Microsoft Excel where the renderer supports this kind of interactivity.

In the Group Properties, on the Visibility tab, select Hide, select “Display can be toggled by this report item”, and select the parent group.

Ssrs Hierarchy

The visibility must be set up on the group and not on the Text box.

Ssrs Text Box Properties

Discover More
Ssrs Report Designer Pane
SQL Server - Reporting Services (SSRS)

SQL Server Reporting Services (SSRS) is a platform for creating, publishing, and managing reports from Microsoft. SSRS competes with Crystal Reports, BI Publisher and other business intelligence tools,...

Share this page:
Follow us:
Task Runner