On Thu, 2006-07-27 at 20:25, Roberto Aguilar wrote: > I wasn't sure how hidden paragraphs worked and believed that the > condition itself would control the insertion of address2, so it is > missing altogether. But, that's not the problem, doh! Or, at least, > I'm still running into the problem. > > I've outlined some more observations in the issue: > > http://www.openoffice.org/issues/show_bug.cgi?id=67843 > > and have attached another sample file that shows the problem in more > depth if you're interested. > > Thanks for the help! > -Roberto. > > On 7/27/06, CarlP <[EMAIL PROTECTED]> wrote: > > 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 > > >> > > >Just for the heck of it try "not(address2)" without the quotation marks in > > >your expression.
-- Fred --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]