Removing blank subsummary rows

[iMarcW]

I've set up a simple subsummary report that displays the sum for two levels of break fields. Some of the top-level categories have subcategories and some don't (subcategory field is empty). So here's what I get now:

Category I       10

  Subcategory a   6

  Subcategory b   4



Category II      12

                 12



Category III      8

 Subcategory a    5

 Subcategory c    3

What I want is to get rid of that extra "12", in other words, not show the subsummary part if the break field is blank for that category.

I tried using conditional formatting comparing GetSummary calculations to try and make the sum field white if the category and subcategory totals are the same, but I haven't figured it out yet, and I'm thinking there must be a better way anyway. Any ideas?

[comment]

I don't think you can remove the sub-summary part. You can hide the value conditionally when IsEmpty ( BreakField ).

[comment]

On second thought:

If you define a calculation field as =

Case ( not IsEmpty ( Breakfield ) ; GetSummary ( Summaryfield ; Breakfield ) )

and use it in your sub-summary part, you can make the sub-summary part "disappear" by using sliding.

[iMarcW]

Thanks--I think one of those two things will work. It's not important that the space disappear, but the extra sum looks silly just sitting there.