7 Replies Latest reply: Jul 17, 2013 8:28 AM by housetiger77 RSS

    Suppress blank columns

    housetiger77

      I have the following columns:

       

      company

      address1

      address2

      city || ', ' || state || ' ' || zip

       

      Sometimes address 2 will be blank because there is no data for that column. I want to be able to suppress that blank space that it leaves because of the no data. I've tried anchoring the objects together and then choosing to collapse them, but that doesn't seem to work for me. I'm not sure if there is something more to it then just that or not. If so, could someone please tell me what else I need to do? Is there any other way to make the blank spaces suppress? Any help is appreciated, thanks!!