Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 458
  • Last Modified:

Suppressing Group 1 when Group 2 has data suppressed

I have a report that has Group 1 and Group 2.  The data in Group 2 is sometimes suppressed dependent on data values.  There are scenarios that there is no data printed in Group 2. If there is no data in Group 2, then Group 1 needs to be suppressed.  How can this be accomplished?
Thank you.
0
garyjgs
Asked:
garyjgs
  • 3
  • 3
  • 2
1 Solution
 
mlmccCommented:
Is this the same group or an inner group?

mlmcc
0
 
LinInDenverCommented:
Is Group 2 higher than Group 1?

When you say "no data is printed in Group 2", do you mean as a result of your conditional suppression? If so, try applying the same logic to Group 1 (only if Group 1 is a subset of Group 2).

Or try Suppress BLank Rows, or Suppress Blank Section (inside Section expert for Group Headers, Footers, and Detail.

If Group 2 is a subset of Group 1, you can try to conditionally suppress Group 2 header/footer with:

If sum({field},{Group1}) = 0
then YES else NO

or, if max({field},{Group1}) = ''
then YES else NO
0
 
garyjgsAuthor Commented:
Group 2 is an inner group of Group 1
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

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

 
mlmccCommented:
What are the reasons Group2 is suppressed?

I assume you have

GH1
   GH2  
   Details
   GF2
   GH2  
   Details
   GF2
   GH2  
   Details
   GF2
GF1

Sometimes all the G2 information is suppressed and you want GH1 and GF1 to be suppressed

The only way is to suppress using similar tests as the suppression of G2

mlmcc
0
 
garyjgsAuthor Commented:
The report is a payroll report and there are conditions, such as, part time employees wiith a certain status are suppressed depending on the department or area that the employee is working at the time, in Grooup 2.

Group 1 represents the company and Group 2 represents the department within the company.

There are mulltiple companies, Group 1.
0
 
LinInDenverCommented:
gary, did you try my suggestions, above? Any errors, or just not work at all?
0
 
mlmccCommented:
You could try this idea
Name - DisplaysInGroup2
If ThisRecordDisplaysInGroup2 then
  1
Else
  0

You could suppress GH1 with
Sum({DisplaysInGroup2},{Group1Field}) = 0

mlmcc
0
 
garyjgsAuthor Commented:
It worked
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

  • 3
  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now