I have the following code:

TABLE FILE EMPLOYEES

SUM
     CNT.TERRITORY_ID AS 'COUNT,TERRITORY_ID'
BY FullName AS 'FULL,NAME'
BY HOMEPHONE AS 'HOME,PHONE'
BY TERRITORYDESCRIPTION

ON FullName SUBTOTAL
     TERRITORY_ID AS 'TOTAL TERRITORIES FOR  '
ON FullName SKIP-LINE
ON TABLE SUBFOOT
"<TABPAGENO "
ON TABLE SET PAGE-NUM OFF
ON TABLE COLUMN-TOTAL AS 'TOTAL'
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     UNITS=IN,
     SQUEEZE=ON,
     ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
     GRID=OFF,
     FONT='TIMES NEW ROMAN',
     SIZE=10,
     COLOR='BLACK',
     BACKCOLOR='NONE',
     STYLE=NORMAL,
$
ENDSTYLE
END

By doing this I'm able to see the Total of the Territories for each employee. However I want to make the field territory invisible. When I do this, my subtotal is then blank also. How can I get the SUBTOTAL on each fullname but not show the list of count on the page.

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

not sure why my question is truncated.

How can I make this
"FULL NAME" "HOME PHONE" "COUNT TERRITORY_ID" "TERRITORY DESCRIPTION"

Buchanan, Steven (71) 555-4848 7 Providence
Morristown
Edison
New York
New York
Mellvile
Fairport
TOTAL TERRITORIES FOR Buchanan, Steven 7

Show the total of 7 even if I make the "COUNT TERRITORY_ID" invisible?

Try using a SUBFOOT instead of the SUBTOTAL. Use the ST. prefix in the SUBFOOT to get a SUBTOTAL for the hidden field.

TABLE FILE CAR
PRINT MODEL AS ''
COMPUTE CNTMODEL/D9=1; NOPRINT
BY COUNTRY NOPRINT
ON COUNTRY SUBHEAD
"<COUNTRY"
ON COUNTRY SUBFOOT
"Total Models for <COUNTRY : <ST.CNTMODEL"
ON TABLE SET STYLE *
TYPE=SUBHEAD, STYLE=BOLD, COLOR=RED,$
TYPE=SUBFOOT, STYLE=BOLD, COLOR=NAVY,$
TYPE=DATA, STYLE=BOLD, COLOR=BLACK,$
ENDSTYLE
END

Have you tried a subfoot with the the count of the territories placed in a computed field which is invisible as well I'm assuming you want to have NOPRINT on so the count is not in a column. The subfoot would contain:
"TOTAL TERRITORIES FOR

Anyway, as mgrackin says as we were on, me and code tags aren't working.

Leah

When I use this code:

TABLE FILE EMPLOYEES
PRINT
     TERRITORYDESCRIPTION AS 'TERRITORY,DESCRIPTION'
     COMPUTE CNTTERRITORY/D9 = 1;
BY FullName AS 'FULL,NAME'
BY HOMEPHONE AS 'HOME,PHONE'
HEADING
"<TABPAGENO "
ON FullName SUBTOTAL CNTTERRITORY
FOOTING
"Total Territories for <EMPLOYEEID "
" "
" "
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     UNITS=IN,
     SQUEEZE=ON,
     ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
     GRID=OFF,
     FONT='TIMES NEW ROMAN',
     SIZE=10,
     COLOR='BLACK',
     BACKCOLOR='NONE',
     STYLE=NORMAL,
$
ENDSTYLE
END

I get subtotals. If I do a NOPRINT on the compute then I don't get the totals. I tried switching to SUBFOOT like you suggested using this code:

TABLE FILE EMPLOYEES
PRINT
     TERRITORYDESCRIPTION AS 'TERRITORY,DESCRIPTION'
     COMPUTE CNTTERRITORY/D9 = 1;
BY FullName AS 'FULL,NAME'
BY HOMEPHONE AS 'HOME,PHONE'
HEADING
"<TABPAGENO "
ON FullName SUBFOOT CNTTERRITORY
FOOTING
"Total Territories for <EMPLOYEEID "
" "
" "
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     UNITS=IN,
     SQUEEZE=ON,
     ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
     GRID=OFF,
     FONT='TIMES NEW ROMAN',
     SIZE=10,
     COLOR='BLACK',
     BACKCOLOR='NONE',
     STYLE=NORMAL,
$
ENDSTYLE
END

Not even making the Compute invisible, I get this error
0 ERROR AT OR NEAR LINE 31 IN PROCEDURE ADHOCRQ FOCEXEC *
(FOC096) WARNING. NO TEXT SUPPLIED BELOW SUBHEAD OR SUBFOOT
0 ERROR AT OR NEAR LINE 32 IN PROCEDURE ADHOCRQ FOCEXEC *
(FOC096) WARNING. NO TEXT SUPPLIED BELOW SUBHEAD OR SUBFOOT
0 ERROR AT OR NEAR LINE 33 IN PROCEDURE ADHOCRQ FOCEXEC *
(FOC002) A WORD IS NOT RECOGNIZED: "Total Territories for BYPASSING TO END OF COMMAND
(FOC009) INCOMPLETE REQUEST STATEMENT

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

I seem to keep having problems posting. Here’s what I’m trying to do with the subfoot like you suggested:

PRINT
     TERRITORYDESCRIPTION AS 'TERRITORY,DESCRIPTION'
     COMPUTE CNTTERRITORY/D9 = 1;NOPRINT
BY FullName AS 'FULL,NAME'
BY HOMEPHONE AS 'HOME,PHONE'
HEADING
"<TABPAGENO "
ON FullName SUBFOOT CNTTERRITORY
FOOTING
"Total Territories for <EMPLOYEEID "
" "
" "
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     UNITS=IN,
     SQUEEZE=ON,
     ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
     GRID=OFF,
     FONT='TIMES NEW ROMAN',
     SIZE=10,
     COLOR='BLACK',
     BACKCOLOR='NONE',
     STYLE=NORMAL,
$
ENDSTYLE
END

I get this error:
0 ERROR AT OR NEAR LINE 31 IN PROCEDURE ADHOCRQ FOCEXEC *
(FOC096) WARNING. NO TEXT SUPPLIED BELOW SUBHEAD OR SUBFOOT
0 ERROR AT OR NEAR LINE 32 IN PROCEDURE ADHOCRQ FOCEXEC *
(FOC096) WARNING. NO TEXT SUPPLIED BELOW SUBHEAD OR SUBFOOT
0 ERROR AT OR NEAR LINE 33 IN PROCEDURE ADHOCRQ FOCEXEC *
(FOC002) A WORD IS NOT RECOGNIZED: "Total Territories for BYPASSING TO END OF COMMAND
(FOC009) INCOMPLETE REQUEST STATEMENT

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

Ginny,

When you post code, include it between [ code] and [ /code] tags (no spaces). You can go back and edit your posts by clicking on the middle icon (between the "quote post" and "report post" icons).

T