Solved

How can I suppress blank group?

Posted on 2010-09-02
10
327 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
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

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 …
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

832 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