OK, I took a quick look, and on a PC (WinXP) I see a mix of line breaks
and paragraph ends for each line of the address window when I turn on
the non-printing characters. The Hidden paragraph line has a line break
character and not a paragraph end character at the END of it, so I
wonder (this is a stretch I know) if it's viewed by the hidden paragraph
condition as not being the end of a paragraph. Since there is state and
city info following it, perhaps the line get's printed. I don't know if
that's the problem or not.
On another note, I see the hidden paragraph condition, but I don't see
the merge field <address2> on that line. Did you first add the address2
field to that line (you can drag and drop from the data source window)
and then add the hidden paragraph condition to that line (should work
before or after the merge field)? I wonder if that could be the problem?
I can't get access to the table data (though I do get merge data when
turning off the field name view) so I can't really explore this further.
Finally, I'll take a look on my mac when I get home.
Carl
Roberto Aguilar wrote:
> Hi Carl,
>
> There are no special characters; the field names are plain ascii.
>
> I have turned off "hidden paragraphs" in the view menu.
>
> Also, I was able to reproduce the problem without the JDBC connection.
> The testcase files are in the issue I mentioned earlier:
>
> http://www.openoffice.org/issues/show_bug.cgi?id=67843
>
> Thanks for the help!
> -Roberto.
>
> On 7/27/06, CarlP <[EMAIL PROTECTED]> wrote:
>
>> 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]
>>
>>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
