Solved

Supress a blank Section

Posted on 2006-11-27
5
877 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
Horizontal Lines in crystal reports 6 75
across tab - Distinct Count - Crystal Reports 2 81
Parameter transfer to cristal report 3 74
Mask on Parameter CR2008 28 51
Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
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…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

813 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now