Hi All

In COMPOUND BYTOC when i'm using Grand Total for each tab sheet i'm getting extra Tab sheet name "TOTAL"

how to remove the Tab sheet name "TOTAL"
i want to show only BY REGION values Tab sheet

  
TABLE FILE ibisamp/ggsales
SUM UNITS/D12C DOLLARS/D12CM
BY REGION NOPRINT
BY CATEGORY
BY PRODUCT
HEADING
"<REGION Region Sales"
ON CATEGORY SUBTOTAL AS 'Total: '
ON REGION SUBTOTAL AS 'Grand Total: '
ON TABLE SET BYDISPLAY OFF
ON TABLE SET COMPOUND BYTOC
ON TABLE PCHOLD FORMAT EXL07
ON TABLE SET STYLE *
TYPE=REPORT, FONT=ARIAL,SIZE=9,$
TYPE=HEADING, SIZE=12,$
TYPE=TITLE, BACKCOLOR=GREY,COLOR=WHITE, $
TYPE=SUBTOTAL,STYLE=BOLD,BACKCOLOR=RGB(221 235 247), SIZE=10,$
ENDSTYLE
END
 

Thank you in advance

This message has been edited. Last edited by: FP Mod Chuck,

Add the following line to your code

ON TABLE NOTOTAL