Conditionally suppress a line of data 1

[YANKRAY]

Using CR 9.0,

I am trying to conditionally suppress a line of data if one of the fields is blank. For example:

Item no batch change location
123 85 NO
456 80 NO
81 NO
789 83 NO

I want to suppress the line that has batch 81.

Thanks,

 

[lbass]

Go to the section expert->details->suppress->x+2 and enter:

isnull({table.itemno}) or
isnull({table.batch}) or
isnull({table.changelocation})

Substitute your correct table/field names.

Or, you could change your record selection formula to:

not isnull({table.itemno}) and
not isnull({table.batch}) and
not isnull({table.changelocation})

-LB