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

suppressing 'empty' blob-fields

Status
Not open for further replies.

JeroenBoon

Technical User
Aug 15, 2002
106
NL
Hello,

we have a table with itemnumber and a blob-field filled with a picture.
In some cases we don't have a picture of an item, so the blob is empty. CR prints an empty blob-field.
Is there a way to tell CR to suppress the empty blob-fields?

Jeroen Boon.
 
place the blob field in a separate details section, and conditionally suppress the section if the blob field is blank with the following formula:

IsNull({BlobField}) Software Training and Support for Macola, Crystal Reports and Goldmine
251-621-8972
dgilsdorf@mchsi.com
 
Alternatively, you can format the section to "suppress blank section". Software Training and Support for Macola, Crystal Reports and Goldmine
251-621-8972
dgilsdorf@mchsi.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top