Solved

Suppress Group Header when Details Section is empty (Due to conditional suppression)

Posted on 2004-10-01
6
256 Views
Last Modified: 2012-06-21
My report looks like this

Group A Header
   Data 1, Data 2, Data 3
   Data 1, Data 2, Data 3
   
Group A Header
   Data 1, Data 2, Data 3
   Data 1, Data 2, Data 3
   Data 1, Data 2, Data 3

I have a condition suppression on the Details Section: if Data1+Data2+Data3 = Value Then Suppress  (again this suppression is not on the data values - it is on the Details Section - Section Expert - using a formula)

In the above example if both Data Sets are suppressed (first grouping) my report looks like this:

Group A Header
   
Group A Header
   Data 1, Data 2, Data 3
   Data 1, Data 2, Data 3
   Data 1, Data 2, Data 3

- I want the Group A Header to be suppressed as well. In the above example the Details Section was suppressed two times - but those where the only two lines of data - so now there is no data in that Group - so I need the Header suppressed.

Thanks





0
Comment
Question by:Callis_Ogles
[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
6 Comments
 
LVL 28

Accepted Solution

by:
bdreed35 earned 400 total points
ID: 12203767
Instead of suppressing each section, use the Group Selection to suppress the whole group.

Report menu, Selection Formulas, group.
In the editor, enter the following:

sum({table.data1},{table.groupAfield}) + sum({table.data2},{table.groupAfield}) + sum({table.data3},{table.groupAfield}) > 0

This will suppress the whole group, header, footer, and details.

You can leave the details section suppression for individual lines.
0
 

Author Comment

by:Callis_Ogles
ID: 12219503
OK - sorry - I need to be more specific - I was trying to keep it simple before. It looks like this will work but here is the problem.

I have three formula fields in the Details section that are doing text comparisons. for example
Formula1
if (Name1 in Name2) then "Yes"
else "No"

Formula2
If (Company1 in Company2) then "Yes"
else "No"

Formula3
if (Description1 in Descritpion2) then "Yes"
else if (Description1 = "Exception1") And (Description2 = "Exception2") then Yes
else "No"

the purpose of my report is to create  an "exception" report - if data matches up then I don't want to see the data.
So, again, in the Details Section Expert using the formula editor on the supression field. I put this:
 
if  {@Formula1}= "Yes"
And {@Formula2}="Yes"
And {@Formula3}="Yes" then True // if all 3 match I don't need to see this line of data
else False

So now - following your previous recomendation to use the "Group Selection to suppress the whole group" - I am just not sure how to do this since I am evaluating these formulas and not data directly from a table.

I am increasing the points - since this is essentially a new question.








0
 
LVL 101

Expert Comment

by:mlmcc
ID: 12429758
I don't know why I missed the latest comment.  Do you still need help?

mlmcc
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

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. …
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…
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

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