suppressing blank sections
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=20911
Printed Date: 27 Apr 2024 at 7:12pm
Topic: suppressing blank sections
Posted By: SSLead
Subject: suppressing blank sections
Date Posted: 24 Jul 2014 at 5:55am
|
I have 3 groups in my report and checked off "Suppress blank sections" in the section expert for each group. however, it is still printing the blank fields in the groups. What else can I do to ensure that the blank fields are not displayed in the groups in the reports?
|
Replies:
Posted By: SSLead
Date Posted: 24 Jul 2014 at 10:02am
I figured it out. I had to add a formula using isnull and the relevant field name into each section's Suppress (No drill-down) option.
isnull({TASKS.TYPE})
|
Posted By: SSLead
Date Posted: 24 Jul 2014 at 10:53am
I spoke too soon. It worked for the first two but for some reason on the 3rd group, if someone leaves that field blank, it still shows up in the report even with that section checked to suppress if blank and with the isnull formula. Please let me know if there is anything else I can try.
|
Posted By: SSLead
Date Posted: 30 Jul 2014 at 9:26am
I figured this out. The last group needed an additional command in the formula to suppress the lingering blank fields that were showing in the report.
isnull({TASKS.WOTYPE3}) or {TASKS.WOTYPE3}=""
|
|