Hello, I am printing out envelopes and am trying to hide "address2" if the entry does not have a sub-address.
First, my data is from postgres, which is linked to OO Base using jdbc. In: Tools -> Options -> Openoffice.org Base -> Databases I give the db a name mydb. Next, I created a query that I want to use for my mail merge and name it gifts. I then created a blank document, then went to Insert -> Envelope and setup the envelope.
From here, I can see all the data from my query set filling in the
envelope information in the format: <name> <address1> <address2> <city>, <state> <zip> Now, I'd like to hide <address2> if it's blank, so in: Insert -> fields -> other -> functions I select "Hidden Paragraph" and set the condition to: mydb.gifts.address2 EQ "" But, that does not work. I always see a blank line. I'm pretty sure I followed the documentation properlly. Any help is greatly appreciated! Thanks! -Roberto. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
