Roberto Aguilar wrote:
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.
Do you have any unusual characters in the field name? I had the same
problem when field names contained any prohibited Windows characters
(e.g. /\|><*$# etc.). My data source (Filemaker Pro 5) allows such
characters and my problem fields contained them.
Also, make sure the "Hidden Paragraphs" option is off in the View menu.
Lastly, I haven't tried to suppress fields with a JDBC or ODBC source,
so maybe the problem lies there somehow.
Carl
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
