Solved

Supress a blank Section

Posted on 2006-11-27
5
881 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
5 Comments
 
LVL 101

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 101

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

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

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

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…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…

623 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