Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Crystal Report GH Suppress Formula not acting as expected

Posted on 2016-09-16
10
Medium Priority
?
79 Views
Last Modified: 2016-09-19
Hi Experts;

I have a three part formula used to suppress a group header when all of that group's details are suppressed. I had to use a three part formula since the actual suppression condition is a formula, which can't be summarized.
The three part formula itself is working fine, I've got the reset formula in the group header, the increment/counter formula in the details, and the totals formula in the group footer.
However, the group header suppression seems like it's suppressing based on the count of the previous group.
Here's without any GH's suppressed:
suppress1I blocked out the actual customer name, but you can see their ID number to the very left.  All customer group headers should remain unsuppressed except for C01453 and C01454 - all the detail records are suppressed and the formula @totals accurately shows 0.00
When I place the formula {@totals}=0 in the suppress area of the section expert for the group header, here's what I'm getting:
suppress2Group header for C01067 got suppressed, and while C01454 did suppress as expected, C01453 is still showing and should not be.
I've experimented with my formulas in all the various header/footer sections, and nothing seems to give me the result I'm expecting.
Any advice is appreciated!
0
Comment
Question by:tkriegel
  • 6
  • 4
10 Comments
 
LVL 1

Author Comment

by:tkriegel
ID: 41801869
Let me know if you can't see the pics - they were visible when I previewed my post, but they don't appear for me now.  Frustrating
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 41802041
The problem is the way a report is rendered.

The group header section is completed before the first detail record for it is evaluated.  Your summaries aren't done until the last detail record is evaluated thus the value you need for suppressing the group header isn't evaluated and available for testing until all the detail records thus the group header cannot be suppressed based on the value for its records.

However the group header suppression will be evaluated using the value currently available which is based on the previous group detail records.

If you need to suppress the group header based on records being displayed in the group you need to develop a formula that can be evaluated in the group header.

Can you scrub the report so you can upload the rpt with data?  If you think that is too difficult then upload the rpt file without data so we can see the formulas used to control the suppression.

mlmcc
0
 
LVL 1

Author Comment

by:tkriegel
ID: 41802124
I've never tried attaching a whole report, let's give it a try....
EDI-Cancellations.rpt
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 101

Expert Comment

by:mlmcc
ID: 41802272
I took a quick look at the formulas used to calculate the totals formula.  Several of them use the MAXIMUM function which is a Print Time function.

The only way I can think to do this is to create a subreport that calculates the value and returns it to the main report as a shard variable.

I'll look at it in more detail tonight.

mlmcc
0
 
LVL 1

Author Comment

by:tkriegel
ID: 41802275
Thanks mlmcc.  If you do come across anything, I'll respond on Monday, I don't have access to CR on the weekends.
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 41802281
That's fine.  It will probably take me most of the weekend to find time to get to this.

I think I can use the report itself stripped of everything not related to calculating the value.

mlmcc
1
 
LVL 101

Accepted Solution

by:
mlmcc earned 2000 total points
ID: 41804759
0
 
LVL 1

Author Comment

by:tkriegel
ID: 41805000
Hi mlmcc - My system won't let me open the attachments due to security concerns.  Any other ideas how I can access them?
0
 
LVL 1

Author Comment

by:tkriegel
ID: 41805049
Hang on - never mind - used a different browser and was able to open the attachments.  Sorry about that.
0
 
LVL 1

Author Closing Comment

by:tkriegel
ID: 41805065
Perfect, thank you so much, this is exactly what I was trying to do!
0

Featured Post

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.

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…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…
Suggested Courses
Course of the Month11 days, 20 hours left to enroll

916 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