Search code examples
reporting-servicesssrs-2008ssrs-tablix

How to hide one row in a rowgroup?


I have a report in SSRS 2008 that has the following structure:

List
  Tablix
    Row Group
      Row1
        Field
      Row2
        Subreport

Is it possible to completely hide the first row in the row group, based on some condition?

I can hide the row, but the empty row still takes up space, I want the empty row to take up no space at all.


Solution

  • Part of the answer is given in the discussion that this question links to:

    Try to set the Hidden property of the Static Row Group under the Details Group, in this case the whole row will disappear instead of the content of the textboxes.If you are using Report Builder, you need to switch to Advanced Mode (make sure that the Properties and the Grouping windows are displayed, go to the upper right side of the Grouping window and press the black triangle), click on the second "Static" item under the "(Details)" group and you can set the Hidden property on the Properties window.

    However, this causes an exception when trying to export the report as PDF.