Solved

Supress a blank Section

Posted on 2006-11-27
5
879 Views
Last Modified: 2012-05-05
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!
0
Comment
Question by:ommer
  • 2
5 Comments
 
LVL 100

Accepted Solution

by:
mlmcc earned 125 total points
ID: 18020489
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
 

Author Comment

by:ommer
ID: 18020857

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
 
LVL 100

Expert Comment

by:mlmcc
ID: 18021220
>>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

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Not Exists 3 74
Crystal Reports 9 and Subreports 3 76
Crystal Reports - group header 2 47
Pass value to stored procedure without using a parameter prompt 3 68
I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

792 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question