I am trying to put subtotals at the top of the report output instead of below each sort break.

I tested the code that is referenced in Dev Studio but is does not produce the desired results.

TABLE FILE EMPLOYEE
SUM DED_AMT GROSS
BY DEPARTMENT
BY DED_CODE
BY LAST_NAME
WHERE BANK_ACCT NE 0
WHERE DED_CODE EQ 'FICA' OR 'CITY'
ON DEPARTMENT SUBTOTAL
ON TABLE SET SUBTOTALS ABOVE
ON TABLE SET PAGE NOPAGE
END

Thank you.

WebFOCUS 7.6.9
DevStudio: 7.6.9

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

This setting was introduced after version 7.6.9

Hi i can across this feature which I love. However, I was wondering if anyone can tell me if you can have a combination of above and below. I would like my subtotals below but I want my grand total above. I've tried
On "BY FIELD" SET SUBTOTAL BELOW
ON TABLE SET TOTAL-COLUMN ABOVE
with "By Field" being a sorted field in procedure.

I'm a missing something or it not possible to combine the two in one procedure?

A