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:
    Implementing Drilldown with row visibility
  2. Doing so displays Row Visibility dialog box. Set the details to Hide when the report is initially running (this will give the drillthrough effect in our example).
  3. Select Display can be toggled by this report item. Select Product from the drop-down list as shown in the following screenshot:
    Implementing Drilldown with row visibility

We can also use an expression to show or hide the details, depending on the condition we specify. But let's go ahead and just select Hide.

Now, let's take a look at our report with the added collapsible grouping:

Implementing Drilldown with row visibility
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
3.128.198.59