Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: suppressing blank sections Post Reply Post New Topic
Author Message
SSLead
Newbie
Newbie


Joined: 15 Jul 2014
Online Status: Offline
Posts: 18
Quote SSLead Replybullet Topic: suppressing blank sections
    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?
IP IP Logged
SSLead
Newbie
Newbie


Joined: 15 Jul 2014
Online Status: Offline
Posts: 18
Quote SSLead Replybullet 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})
IP IP Logged
SSLead
Newbie
Newbie


Joined: 15 Jul 2014
Online Status: Offline
Posts: 18
Quote SSLead Replybullet 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.
IP IP Logged
SSLead
Newbie
Newbie


Joined: 15 Jul 2014
Online Status: Offline
Posts: 18
Quote SSLead Replybullet 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}=""
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.