Anyone know how to compute a subtotal in the recap section? I'm doing something like this:

--------------------------------------
TABLE FILE TEMP
PRINT
COUNT_T1
COUNT_T2
ON TEMP_FLAG RECAP
TOTAL/D20 = COUNT_T1 + COUNT_T2;
ON TABLE SUBFOOT
"<+>TOTAL<+>"
ON TABLE SET STYLE *
TYPE = SUBFOOT
, HEADALIGN = BODY
, $
ENDSTYLE
END
-RUN
-EXIT
--------------------------------------

In a SUBFOOTER I want to display ST.COUNT_T1 with a $ in 'some' situations. Any thoughts?

Aaron M Reiff
Prod - WebFocus 7.66
Prod - ReportCaster 5
Win Server 2K/ISAPI/MSSQL Server 2K
--------------------
Test - WebFocus 7.66
Win Server 2003/TomCat/MSSQL Server 2K
--------------------
Dev - WebFocus 7.66
Win Server 2003/TomCat/MSSQL Server 2K

Do you really need the RECAP? Can't you just DEFINE the field you need to subtotal and then include that field in your subfoot? Then you could conditionally display the subfoot summary (with/without $) based on a WHEN.

Here's the example included in the Creating Reports with WF Language documentation, Chapter Including Totals and Subtotals, Topic Conditionally Displaying Summary Lines and Text

TABLE FILE GGSALES
SUM UNITS DOLLARS
BY REGION
BY CATEGORY
ON REGION SUBTOTAL
WHEN DOLLARS GT 11500000
SUBFOOT
"The total for the (REGION region is less than 11500000."
WHEN DOLLARS LT 11500000
END

To display properly, I changed the lessthan REGION to (REGION

This will cause the subtotal to be displayed when the DOLLARS subtotal is greater than 11500000 and the SUBFOOT text will display when the DOLLARS subtotal is less than 11500000.

Deb

P.S.
Here's another possibility . . .
Use the RECOMPUTE instead of RECAP. If you DEFINE or COMPUTE your Total field, you can include it in the RECOMPUTE and also include the prefix operator SUM. COUNT_T1.
It should look something like
ON TABLE RECOMPUTE Total SUM. COUNT_T1

Deb

This message has been edited. Last edited by: debbiej,

Deb

I wanted to use the recap because I'm using it for another reason and had it around anyway. In the end, I tried this:

ON FLAG RECAP
THIS_TOTAL/A30 = IF FLAG EQ 'A' THEN FTOA(SUM.COUNT_T1, '(D20BM)', THIS_TOTAL) ELSE FTOA(SUM_COUNT_T1, '(D20)', THIS_TOTAL);
...
...
...

This got the desired result of a $ in the situations I wanted. Thanks for the help!

A