The user wants subtotals on their excel2k report. This code provides subtotals but it puts the field name in the subtotal. So, they see TOTAL DESC GENERAL REPORTS and they just want to see TOTAL GENERAL REPORTS. I've tried using subfoots but then the totals don't align even if I put positioning in the stylesheet. If I use column-total then a subtotal appears for each by statement and they only want a subtotal at desc and a final total. Suggestions??? Thanks

TABLE FILE HOLDSAT
SUM
CNT.REPORT_NAME AS 'Count'
COMPUTE OPTIONPDF/I8 MISSING ON=IF OPTIONPDF IS MISSING THEN 0 ELSE OPTIONPDF; AS 'Output Format,PDF'
COMPUTE OPTIONHTML/I8 MISSING ON=IF OPTIONHTML IS MISSING THEN 0 ELSE OPTIONHTML; AS 'Output Format,HTML'
COMPUTE OPTIONEXCEL/I8 MISSING ON=IF OPTIONEXCEL IS MISSING THEN 0 ELSE OPTIONEXCEL; AS 'Output Format,EXCEL'
COMPUTE OPTIONCSV/I8 MISSING ON=IF OPTIONCSV IS MISSING THEN 0 ELSE OPTIONCSV; AS 'Output Format,CSV'
BY ORDER NOPRINT
BY DESC NOPRINT
BY TOTAL HIGHEST CNT.REPORT_NAME NOPRINT
BY NAME AS 'Report Name'

ON DESC SUBTOTAL

ON DESC SUBHEAD
"

webfocus 8.105M; os: windows; pdf, html, exl2k, csv

check this forum,

https://forums.informationbuilders.com/eve/forums/a/tpc/...931098331#8931098331

thanks ... that worked. I tried searching for excel posts but didn't come across the one you attached, so thanks for guiding me in that direction.

I've been struggling with Excel placement as well, this week. You can use SUBFOOT if you use TABFOOTING in the style sheet to control the placement of the data into the desired Excel cell(s). Use a spot marker <+0> between the SUBFOOT text and the first data item. Seperate each item by a space if you want to skip columns.

Consecutive columns could be defined this way:

ON TABLE SUBFOOT
"Total Net Expense <+0>
TYPE=TABFOOTING, HEADALIGN=BODY,$
TYPE=TABFOOTING, OBJECT=FIELD, ITEM=1, JUSTIFY=RIGHT, COLOR=RED,$
TYPE=TABFOOTING, OBJECT=FIELD, ITEM=2, JUSTIFY=RIGHT, COLOR=BLUE,$
TYPE=TABFOOTING, OBJECT=FIELD, ITEM=3, JUSTIFY=RIGHT, COLOR=GREEN,$

Items 1, 2, and 3 refer to the ST's defined in the SUBFOOT statement and do not include any spaces between the ST's.

If you want to skip a column in Excel between COL2 and COL3 (perhaps you have column between them that you do not want to subtotal) you could define it this way:

ON TABLE SUBFOOT
"Total Net Expense <+0>
TYPE=TABFOOTING, HEADALIGN=BODY,$
TYPE=TABFOOTING, OBJECT=FIELD, ITEM=1, JUSTIFY=RIGHT, COLOR=RED,$
TYPE=TABFOOTING, OBJECT=FIELD, ITEM=2, JUSTIFY=RIGHT, COLOR=BLUE,$
TYPE=TABFOOTING, OBJECT=FIELD, ITEM=3, JUSTIFY=RIGHT, COLOR=GREEN,$

Note the space between
Another of our developer's has used TABHEADING to equal effect.

WebFocus 7.1.4 Win2K Client

WebFocus 7.1.6 Server