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

Removing Empty Space

Status
Not open for further replies.
Jan 27, 2005
76
US
My report has Details section with one row of fields and a second line for Notes. If the notes are empty, I want to suppress that empty space. I have done this before but I cannot get this to work. Any clues?

Thanks!
 
Depends on your version of Crystal, please remember to take the time to post it.

I would suggest that you right click the details section and select insert section below, then move the memo field (Crystal doesn't have a notes type field) into the Details B section.

Right click the Details B section and select Format Section->X2 next to suppress and place:

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

-k

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top