I want to hide the recap fields that are calculated and only display them in the subfoot. My code is below:

ON SUBGROUP_TALLY RECAP
PCT_RCP/P5.1% = (SOLC_DR / DO_DR) * 100;
AG_PCT/P5.1% = (SOLC_DR/FY10_GOAL) * 100;
WHEN SUBGROUP_TALLY EQ '1';

ON SUBGROUP_TALLY SUBFOOT
"" "

The following displays:

** PCT_RCP     40.8
** AG_PCT     1.6

Frost Subtotal 40.8 1.6

I don't want the 2 ** lines to appear in above the subtotal line (subfoot code). What's the secret to hiding them? It errors out if I say NOPRINT.

I'm using WF 7.1.3.

Thanks,

Will

This message has been edited. Last edited by: SLU Will,

I'm not that familiar with RECAP.
But, I was able to remove the "**" from the subtotals.
Take a look this example.

-* Example of RECAP from Dev Studio Help
-* Modified to remove ** from subtotals
TABLE FILE EMPLOYEE
SUM 
     DED_AMT
     GROSS
     COMPUTE DEPT_NET/D8.2M = GROSS-DED_AMT; NOPRINT
BY DEPARTMENT 
BY PAY_DATE
ON DEPARTMENT SUBFOOT
"DEPT_NET <ST.DEPT_NET"
WHEN PAY_DATE GT 820101
END


-EXIT
-*-:SKIP_A
-* Example of RECAP from Dev Studio Help
TABLE FILE EMPLOYEE
SUM 
     DED_AMT
     GROSS
BY DEPARTMENT 
BY PAY_DATE
ON DEPARTMENT RECAP
DEPT_NET/D8.2M = GROSS-DED_AMT;
WHEN PAY_DATE GT 820101
END

quote:

ON SUBGROUP_TALLY RECAP
PCT_RCP/P5.1% = (SOLC_DR / DO_DR) * 100;
AG_PCT/P5.1% = (SOLC_DR/FY10_GOAL) * 100;
WHEN SUBGROUP_TALLY EQ '1';

ON SUBGROUP_TALLY SUBFOOT
"" "

Will,
If you put your RECAP fields in the SUBFOOT they will not be displayed:

  
ON SUBGROUP_TALLY RECAP
PCT_RCP/P5.1% = (SOLC_DR / DO_DR) * 100;
AG_PCT/P5.1% = (SOLC_DR/FY10_GOAL) * 100;
WHEN SUBGROUP_TALLY EQ '1';

ON SUBGROUP_TALLY SUBFOOT
"<PCT_RCP "
"<AG_PCT "
WHEN SUBGROUP_TALLY EQ '1';

Daniel, is totally correct RECAP columns ONLY display if they are not used in a SUBFOOT.

If you learnt how to read the documentation you would have found that out very quickly.

I finally got it to work by making the WHEN statement in the RECAP section greater than any value that would appear on the report. In this instance, I had 3 possible values (1, 2, and 3), so I made it a 5 and the recap fields disappeared from the report. See below for my subtle change from my original post:

ON SUBGROUP_TALLY RECAP
PCT_RCP/P5.1% = (SOLC_DR / DO_DR) * 100;
AG_PCT/P5.1% = (SOLC_DR/FY10_GOAL) * 100;
WHEN SUBGROUP_TALLY EQ '5';

ON SUBGROUP_TALLY SUBFOOT
""WHEN SUBGROUP_TALLY EQ '1';

Thanks.

Will,

With your recap you also specified 'WHEN some condition'.
If you just take that statement out of your request, it also works, since you have the WHEN clause on the subfoot active.
In fact, a WHEN clause on a recap is IMHO a useless clause, the recap will be calculated anyway, as you've noticed.
So just stick with:

ON SUBGROUP_TALLY RECAP
PCT_RCP/P5.1% = (SOLC_DR / DO_DR) * 100;
AG_PCT/P5.1% = (SOLC_DR/FY10_GOAL) * 100;

ON SUBGROUP_TALLY SUBFOOT
"<PCT_RCP"
"<AG_PCT"
WHEN SUBGROUP_TALLY EQ '1';

That should work fine.