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!

Looking for help to suppress detail section if a field is blank

Status
Not open for further replies.

mvalley

Technical User
Mar 4, 2011
80
US
I have a report that has several fields within the detail section. I want to suppress the entire detail section if a certain field within the detail is blank. I tried the section expert suppress with the isnull({field}) but that did not work. I am not familiar with the whileprintingrecords formula but think this might be what I need. Any suggestions for me. Thank you.
 
Are you sure field is null?

Check report options and see if set nulls to default has been checked

or try

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

Ian
 
Sorry, I was unable to work on this report for a few days. the Trim suggestion appears to work. Thank you for your assistance with this issue.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top