"Close" a subsummary row

[nleon307]

Hello

 

I have a subsummary report with a main group and subcategories.

Some main groups only have one subcategory which is the same as the main group.

Other main groups have up to 4 subcategories.

Is there a way to hide the subcategory line for the groups with only one subcategory which is the same as the main group?

 

If it were a pivot table in Excel I would just close the row.

 

Thank you

[nleon307]

While it's going to take a while to get the relationships and calculations right, I deleted the subcategory subsummary part and added a filtered portal to the main subsummary part that slides up and resizes enclosing part. Visually it works, I just need to fight with the calculations to get the report right again.

[nleon307]

In case anyone sees this in the future...

Visually, everything worked how I needed it to.

I had probelms getting the relationship to filter the totals correctly in the portal so I changed the calculations to use the ExecuteSQL function to have more control over the relationships and the report works fine and looks like some subsummary parts are open while others are closed.