Solved

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

Posted on 2007-12-06
5
499 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
Comment Utility
Why is it zero in the header? Are you reseting the values in the header?
0
 
LVL 4

Expert Comment

by:habibb
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

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…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

743 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

21 Experts available now in Live!

Get 1:1 Help Now