Solved

How can I suppress blank group?

Posted on 2010-09-02
10
326 Views
Last Modified: 2012-05-10
I have a group of item type. Under that group, I have the list of items. However, if the item has quality is bad, I suppressed it. Now, the scenario is ITEM TYPE 1 has 2 items which are ITEM 1, ITEM 2 and both of them are bad. Therefore, they are all suppressed and now ITEM TYPE 1 is empty. I want to suppress that ITEM TYPE 1 because it is blank now. I tried to count the number of items in ITEM TYPE but it returns 2 instead of 0 which I expected. Any solution for this?
0
Comment
Question by:YVF
  • 4
  • 3
  • 3
10 Comments
 
LVL 8

Expert Comment

by:kingjely
ID: 33593266

Hi,

If you want to suppress blank Group>
go to section expert> choose the group section to suppress and 'tick' suppress blank section


0
 
LVL 8

Accepted Solution

by:
kingjely earned 400 total points
ID: 33593333

Hi YVF

That's how you suppress a blank group, Did that help, or would you like to upload a sample of your report so we can see what else it is you need to do?

Kj
0
 

Author Comment

by:YVF
ID: 33593442
I tried it before posting question but it doesn't work. I think the reason is that group is not blank because it have items which are bad quality. And I just hide that bad quality items.
0
 
LVL 8

Expert Comment

by:kingjely
ID: 33593452

Instead of hide, can you suppress them if there bad ?

Then suppress the group section? or have you tried that too>

If not want to post a sample, save data with report, and will have a look.. try above first though if you haven't already
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 33593612
Do you need the data for the report?
If not then just change the filter/selection to not select those records.

mlmcc
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 100

Expert Comment

by:mlmcc
ID: 33593620
One way to do this is to create a formula

If {YourQualityField} = "GOOD" then
    1
Else
    0

YOu can then suppress the group with a formula like
Sum({@GoodQuality},{GroupFIeld}) = 0

mlmcc
0
 

Author Comment

by:YVF
ID: 33593799
Hi mlmcc,

I think I can use your second method. However, I got a error say that the field cannot summarized. The reason is I have a Sum() in if clause condition.

Then in suppress formula of the group, I do sum to get all the number of suppressed items to do compare with "COUNT(Item)" and it complained that error.
If ({@Quantity} = 0) AND (Sum ({<ReportName>.Order}, {<ReportName>.ItemCode}) = 0) Then
1
Else
0

Open in new window

0
 
LVL 100

Expert Comment

by:mlmcc
ID: 33605540
In that case you probably can't do it since the headers are done before the details can calculate.

mlmcc
0
 

Author Comment

by:YVF
ID: 33608275
So, is there any solution or not?
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 33608435
You can always calculate it using a formula or a running total and then use it iin the group footer.  The only way to get it in the group header would be in a subreport.

mlmcc
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

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…
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 …
I designed this idea while studying technology in the classroom.  This is a semester long project.  Students are asked to take photographs on a specific topic which they find meaningful, it can be a place or situation such as travel or homelessness.…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

911 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

25 Experts available now in Live!

Get 1:1 Help Now