Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Suppress blank section - text fields always displayed

Status
Not open for further replies.

Petbul

MIS
Jun 20, 2001
56
CZ
Hello, in detail section I have text fields and database fields (db fields can be blank)....But text fields are always displayed...Is there an option how to suppress printing blank sectin? (I am using format section - suppress blank section - text fields are displayed...).
Any idea?
Many thanks.
Petr

Best regards
Petr
 
The section isn't blank because of the text fields, so suppress if blank won't work.

Use a formula in the suppression which checks for blank db fields:

Right click the Details->Format Section->X 2 next to Suppress and enter a formula such as:

isnull({table.field})
or
trim({table.field}) = ""

Base it on a field which would have to be there, or you can base it on multiple fields if need be.

-k
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top