Writer Guide

6) To suppress blank lines:
a) Click at the end of the first paragraph to be suppressed and
then choose Insert > Fields > Other.
b) Select the Functions tab and then click on Hidden
Paragraph in the Type column.
c) Now click in the Condition box and enter the details of the
condition that defines a blank address field. It has the general
form of:
![Database.Table.Database field]
where the ‘!’ (NOT) character indicates the negative case and
the square brackets indicate the condition.
For example, in our Points database the condition to test if the
Company field is empty would be:
![Points.Sheet1.Company] as illustrated in Figure 299.
Figure 299: Hidden paragraph insertion
To test for multiple conditions use the operators AND and/or
OR between the conditional statements, for example:
![Points.Sheet1.Title]AND![Points.Sheet1.Last Name]
d) Click Insert, but do not close the dialog box until you have
amended all the lines that should be suppressed.
356 OpenOffice.org 3.x Writer Guide
Free eBook Edition