Supress a Group Summary 1

[subendu]

We have created a report with Crystal 9. The report has 3 groupings. The third grouping footer has summary of a amount column. The third group has to be suppressed completely if the the summary is "0". How can we achieve this with Crystal 9.

 

[dgillz]

Report, edit selection formula, group.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

dgilsdorf@trianglepartners.com

 

[subendu]

Thanks for the prompt reply.

I have done the same way and have written this formula.

Now, I have a parameter(zeroBalance), based on which I have to supress or show the grouping option.

If the value of zeroBalance is YES and summary is zero then the group has to suppressed else it should not be suppressed.

if ( (Sum ({@curAmount}, {@groupopt3}) <> 0) AND ({?zeroBalance} = &quot;YES&quot ) then true

The report work fines when the parameter has YES, but when parameter is false, then i am not getting any report, the report comes blank.

Please help me, where am I going wrong.

 

[checkai]

It sounds like you want to put the condition in the Section Expert...under the X-2...also what does the zeroBalance check the @curAmount sum?

 

[lbass]

If you are using a group selection formula to accomplish this, your formula should look like this:

if {?zeroBalance} = &quot;Yes&quot; then
Sum({@curAmount}, {@groupopt3})<> 0 else
(Sum({@curAmount}, {@groupopt3}) =
sum({@curAmount}, {@groupopt3})

If the user says &quot;Yes&quot; (eliminate groups with zero balance) then this will display only those groups with balances <> 0. If {?zeroBalance} <> &quot;yes&quot; then no group select will be made, i.e., all groups will display.

-LB

 

[subendu]

Thanks, it worked....