Solved

How can I supress a group header based on a running total in the group footer?

Posted on 2007-12-06
5
501 Views
Last Modified: 2008-03-10
I need to supress a group header using a running total in the group footer.  Does anyone have a suggestion on how to do this?  The running total is always zero in the header and may or may not be a zero in the footer.  I need to supress the header by using the value shown in the footer.
0
Comment
Question by:chryo4096
5 Comments
 
LVL 17

Expert Comment

by:pssandhu
ID: 20421300
Why is it zero in the header? Are you reseting the values in the header?
0
 
LVL 4

Expert Comment

by:habibb
ID: 20426976
you can not do it in simple way however by workaround you will be able to do it.
Workaround:

Place a subreport in group footer and suppress group footer on the basis of running totals i.e. if running total for a particular group header value is 0 then suppress the footer which automatically suppress the sub report
If there is some value in running totals except 0 then pass this group header value to subreport and your sub report will show data for that particular group header value but you must apply the same group in sub report too ( which you are currently applying in  your main report).

you can use link subreport property to pass parameter to subreport at runtime.

hope you got my point.
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 20432321
Since running totals are calculated while the report is printing (final pass of the Crystal process) the group header is already printed when the report footer has the value to test against.

What are you counting or calculating?  Can it be done with a summary function?  Summary functioins are done before the final pass and can be used to suppress the group header.

mlmcc
0
 

Author Comment

by:chryo4096
ID: 20461271
I am creating a Quality Assurance Calibration report.  Basically, multiple users score a customer service call, I then pull the data for all the questions and suppress those questions were the possible and poins are equal (correct) and only show those questions that were marked wrong (as a group) with the nested group being the observer name (I use this data to calculate stddev (observers indicating wrong answer/total observers).  The problem is I use the runnnning total to count the number of observers who marked a question wrong.  As this total does not exit in the header (the question text) it is always zero)  The rt counts the instances of wrong and displays in the footer.  I need to supress the question Text group header for any question where bo observer indicated the function was done incorectly.  Isn't there any formula that can be used to supress the header by evaluating the rt of the group footer GroupFooterName({rtCountOpportunity})??  Or maybe usin the EvaluateAfer(x) function?
0
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
ID: 20461487
YOu could try this

Create a formula
If ({YourFieldforWrong} = TRUE) then
    1
else
    0

You should then be able to create a summary on that field for the roup and test it to suppress the sections you need suppressed.

mlmcc
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
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…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

816 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

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now