Skip to Content
avatar image
Former Member

Remove section headers for empty sections

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    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

    Add comment
    10|10000 characters needed characters exceeded