Suppress Header

[jjenright]

I need to suppress the Group Header for each group that does not have any records in the Group Footer. The footer contains a running total. The footer is suppressed when the running total = zero. I want to suppress the header when the footer is also 'conditionally' suppressed. I am using Crystal 10. "Blank" headers are appearing throughout the report. How can they be suppressed when the footer is suppressed ? Thank You

 

[moliver827]

It should suppress using the same code as the GF.

if isnull({#RTotal0}) then // or zero
true // suppress
else
false // don't suppress

 

[jjenright]

moliver827,

Thank You. It doesn't seem to be working though.

The running total is not calculated until after it is printed in the footer. How can it be calculated in the header and then suppressed if it is zero as I am doing in the footer ? I think whilereading records

Thanks for your help !

 

[lbass]

You can't do this with running totals. Instead try using an summary in your suppression formula. Please explain how the running total was set up--then maybe we can see what summary would make sense.

-LB

 

[jjenright]

The running total is the count of the field {Item} evaluated by a formula {LINE_TYPE}="X" (this represents a special order for an item that is not on an existing contract - not a contract purchase). It is reset when the accounting unit or department changes.

When the count for any accounting unit / department equals zero I need to suppress the header for that group, otherwise show the header.

The count is occuring after the header is printed. How can the count be done in the header and then suppressed if it is zero for that accounting unit / department group ?

Thanks for your help!!

 

[lbass]

Create a formula like this:

//{@linetype}:
if {table.line_type} = "X" then 1

Then use this formula for suppressing the header at the acct unit:

sum({@linetype},{table.acctunit}) = 0

At the department level, use:

sum({@linetype},{table.dept}) = 0

-LB

 

[jjenright]

lbass,

Thank You for your assistance. This worked very well.