Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Remove the extra tab Sheet "TOTAL" when using COMPOUND BYTOC
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Remove the extra tab Sheet "TOTAL" when using COMPOUND BYTOC
 Login/Join
 
Gold member
posted
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,


WebFOCUS 8202
 
Posts: 58 | Location: India | Registered: March 24, 2014Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Add the following line to your code
ON TABLE NOTOTAL


WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
 
Posts: 2296 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Remove the extra tab Sheet "TOTAL" when using COMPOUND BYTOC

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.