Remove section headers for empty sections

[Former Member]

I'm building a report that shows current inventory, current orders, MTD orders, and planned production for several items, and I've used "set as section" to create separate tables for each location where inventory is held. But, when I do this, I am still getting section headers for locations where there all of the above values are zero (these items are not made at these specific locations).

I've figured out how to remove all the rows in individual tables where there are nothing but zeroes coming up, but I still am getting section headers for each location where values are all zero, and then no table underneath. How do I get rid of all the sections where all of the values underneath are zero?

[former_member198519 · Accepted solution]

Did you tried clicking on section and go to Properties -> Format Section and select the option as "Hide when Empty" and also select the option for "Hide when the following formula is True"

= isnull([Section object]) or [Section object]=0

See if that works