Suppress group footer using formula

[jccjill]

I am trying to suppress a group footer when the count is less than 25. In the section expert I have chosen to supress group footer using the following formula: WhilePrintingRecords;{@Count of Approved Swipes}<25

but it isn't working. What am I doing wrong?

 

[lbass]

Please show the content of your nested formula (and any formulas contained within it).

-LB

 

[jccjill]

The formula is the @Count of Approved Swipes formula field in the footer which was created using summary, count. So the formula is

Count ({CARD_ACCESS_HIST.APPROVED})

It is located in the group footer.

Other than that the field choosers are the other formulas and they are:

{CARD_ACCESS_HIST.APPROVED} = "Y" and
{CARD_ACCESS_HIST.DATE_TIME} = {?Dates Swiped} and
{CARD_ACCESS_HIST.CRE_HOS_STATION} = "JCC-FWR-DESK" and
not ({MEM_INFO.MTP_MTY_TYP} like ["JODI*", "OUTSIDE*", "STAFF*"])

 

[lbass]

You don't need to use "whileprintingrecords" in your formula, and the problem is that you have left out the group condition, so it is testing the count for the entire report. It should be:

Count ({CARD_ACCESS_HIST.APPROVED},{table.groupfield}) < 25

-LB

 

[jccjill]

Thank you. That solved it!