Supress a blank Section

ommer
ommer used Ask the Experts™
on
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!
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Senior Consultant
Most Valuable Expert 2011
Top Expert 2013
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

Author

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.
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
>>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

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial