Solved

How can I suppress blank group?

Posted on 2010-09-02
10
331 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
[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
  • 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
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
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 101

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 101

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 101

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 101

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

Get HTML5 Certified

Want to be a web developer? You'll need to know HTML. Prepare for HTML5 certification by enrolling in July's Course of the Month! It's free for Premium Members, Team Accounts, and Qualified Experts.

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…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…

631 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