Search code examples
reporting-servicesssrs-2016

SSRS make parent group heading show for all child groups

I have an SSRS report with the following row groupings:

[Grandparent]
   [Parent]
      [Details]

Currently when the [Parent] group changes value, the [Grandparent] row will disappear in the report unless it's in a new [Grandparent] group. I would like for the [Grandparent] row to always show even when it's the same [Grandparent] but different [Parent]. Is there a way to do this in SSRS?

Solution

  • Why not add another row above [Parent] group but inside the Parent group and get it to display the Grandparent. If the rows repeat themselves when the group changes.. get around it by having a row visibility on the bottom one to check if the values are the same and hide it. something like

    =iif(Previous(Fields!firstgrandparentvalue.Value)= Fields!secondgrandparentvalue.Value, true,false)