ommer
asked on
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!
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!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
>>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
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
ASKER
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.