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.
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
- Thread starter mvalley
- Start date
IanWaterman
Programmer
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
Check report options and see if set nulls to default has been checked
or try
isnull({field}) or trim({field}) = ""
Ian
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question