Problem with suppressing group footer in crystal 9.0 1

[pattid]

Thank you for taking the time to read my question...

I am using Crystal 9.0 and I need to suppress certain information in Grp 2 and the detail section of my main report. What I have done in Grp 2 header, detail, and Grp 2 footer is written the following formula under section expert > suppress > x-2:
[suppress if] {@Redraw} = 0 and {@Return} = 0 and {@Logout} = 0

This formula is working beautifully in the Grp 2 header and detail sections. However, in Grp 2 footer it is not working. I've discovered that the group footer is looking at the very last record in the detail section and only evaluating that record. If that record meets the criteria of {@Redraw} = 0 and {@Return} = 0 and {@Logout} = 0
then it suppresses. This creates a problem because I want to only suppress the loans in Grp 2 footer in which all loans meet the criteria.

To sum it up, this is what I'm getting with the formula I have:
111-BPARK-MNCHSTR (group)
0040382228 (detail)
(group footer - a total should be showing here)

What I want to see is
111-BPARK-MNCHSTR (group)
0040382228 (detail)
Total Rcvd: 2 (group footer)

Any help would be much appreciated.

 

[lbass]

You should always share the content of formulas when you post questions. But if we assume that your nested formulas are based only on detail level fields, then you could write another formula like {@allmeetcrit}:

if {@Redraw} = 0 and
{@Return} = 0 and
{@Logout} = 0 then
1 else 0

Then use a suppression formula like:

sum({@allmeetcrit},{table.group2field}) = count({table.group2field},{table.group2field})

-LB

 

[pattid]

That worked perfectly! Thanks so much for your help and I'll be sure to share the contents of my formulas in future posts. Thanks again!