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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Conditional Suppress

Status
Not open for further replies.

BreffniK

Technical User
Apr 27, 2004
24
US
Thanks for taking the time to read my question.

What is the correct syntax to conditionally suppress a section of the report depending on whether or not a field is null?

Any advice would be greatly appreciated!

Thanks!
 
Hi,
Try:

Code:
IsNull({table.field}) or {table.field}=""

Tests for NULL and Blank..

[profile]
 
or even

isnull({table.field}) or
{table.field} = '' or
{table.field} = ' '
 
Just to make sure it's not filled with blanks,

isnull({table.field}) or
trim({table.field}) =
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top