O'Reilly logo

SQL Server 2012 Reporting Services Blueprints by Mickey Stuewe, Marlon Ribunal

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Implementing Drilldown with row visibility

Implementing an expand/collapse control for groups or simple Drilldown in SSRS is relatively easy. It involves two steps:

  1. Create group (which we already did recently).
  2. Set the visibility property of the details of that group.

    Note

    Adding aggregate and group elements in your report, especially when dealing with huge datasets, may have some negative impact on the rendering performance of your report. If you cannot avoid aggregates and groupings on a huge dataset, consider creating a separate report for that purpose.

Perform the following steps:

  1. Select and right-click on the detail row, then select Row Visibility:
  2. Doing so displays Row Visibility dialog box. Set the details to Hide when the report is initially ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required