Supress a blank Section

Hello, All,

I have a problem and hope you can help.

My report has a "Group Footer" section which contains only one text field.
I want that this section (GF) suppressed when the field is blank or Null.

I notice if I check the supress under that field's format editor, commom, object format, the whole report is blank.

And if I check the Suppress Blank Section under Section Expert of the GF, here comes the interesting, or confusing part,
after I saved it, it worked at first run, i.e. the section is suppressed and report shows everything, then the next run and there after, all I got is blank report. No matter how I flip back and forth with these two check boxes, the report remains blank, unless I remove the field from the report.

I am using vs2003 embedded CR 8.5.

How can I suppress the GF without blank out the report?

I appreciate your help in advance!
ommerAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
mlmccConnect With a Mentor Commented:
Try conditional suppression.

Open the report
Click FORMAT --> FORMAT SECTION
Select the GROUP FOOTER
Click teh FORMULA button to the right of SUPPRESS
Use a formula like
IsNull({TheField})

mlmcc
0
 
ommerAuthor Commented:

Thnks!

I want to make sure I understand correctly on next two minor details, because my data is pretty dynamic and I could not grab a set of data that is not null/blank to test the other half, but at least the null/blank part tested successfully.

First, the formula should be to the right of Suppress Blank Section, not Suppress (No Drill-Down).
Second, I don't need to check the Suppress Blank Section after the formula is in the place. Because if I did, I ended up with a blank report again.
0
 
mlmccCommented:
>>First, the formula should be to the right of Suppress Blank Section, not Suppress (No Drill-Down).
I would try it on SUPPRESS (No Drill-Down)
No reason to allow drilling in if the section is blank

>>Second, I don't need to check the Suppress Blank Section
That is correct

mlmcc
0
All Courses

From novice to tech pro — start learning today.