Skip to Content

Remove section headers for empty sections

Jan 30, 2017 at 01:37 PM


avatar image
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?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Kuldeep Ghosh Jan 31, 2017 at 10:57 AM

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

10 |10000 characters needed characters left characters exceeded