SSRS make parent group heading show for all child groups

0
votes

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?

1
reporting-servicesssrs-2016
Why not add another row above [Parent] group but inside the Parent group and get it to display the Grandparent. – Harry
But then it will show the [Grandparent] twice if the value for [Grandparent] changes no? – Los Morales
If that happens, You can get around that 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) – Harry
that was it thanks! – Los Morales
sweet.. I'll add that as my answer and you can accept that :) – Harry

1 Answers

1
votes

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)