Writer Guide

6) To suppress blank lines:

p) Click at the end of the first paragraph to be suppressed and

then select Insert > Fields > Other.

q) Select the

Functions

tab and then click on Hidden

Paragraph in the

Type

column.

r) 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 300.

Figure 300: Hidden paragraph insertion

To test for multiple conditions use the operators

AND

and/or

between the conditional statements, for example:

![Points.Sheet1.Title]AND![Points.Sheet1.Last Name]

s) Click Insert, but do not close the dialog until you have

amended all the lines that should be suppressed.

348 OpenOffice.org 3 Writer Guide