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,
WillThis message has been edited. Last edited by: SLU Will,
August 05, 2009, 02:59 PM
Mighty Max
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
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 In Focus since 1982 wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF
August 06, 2009, 03:09 AM
<JG>
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.
August 18, 2009, 10:33 PM
SLU Will
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.
August 19, 2009, 07:38 AM
GamP
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';