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     want to get rid of drill down on a total
Go
New
Search
Notify
Tools
Reply
  
want to get rid of drill down on a total
 Login/Join
 
<levada>
posted
I created a cross tab report and I need to get rid of the drill down that is popping up on the total. I only want a drill down on acrossvalue stuff but not on the actual total. Anyone have any ideas? Please email me elliot.siegel@juliusbaer.com as I dont go on the internet often.
thanks
 
Reply With QuoteReport This Post
Gold member
posted Hide Post
Can you provide the sample code you are using?

Here is a sample using CAR. The report has drill downs on the ACROSS data only and the report also has ROW and COLUMN totals.

TABLE FILE CAR
SUM
SALES
BY
MODEL
ACROSS
COUNTRY
ON TABLE SUBHEAD
"Sample Cross Tab with Row Totals and Column Totals"
HEADING
"Drill Down is on data only"
ON TABLE SET PAGE-NUM OFF
ON TABLE ROW-TOTAL AS 'TOTAL'
ON TABLE COLUMN-TOTAL AS 'TOTAL'
ON TABLE SET ONLINE-FMT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
PAGESIZE='SCREEN',
LEFTMARGIN=0.000000,
RIGHTMARGIN=0.000000,
TOPMARGIN=0.000000,
BOTTOMMARGIN=0.000000,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='ARIAL',
SIZE=9,
COLOR='BLACK',
BACKCOLOR='NONE',
STYLE=NORMAL,
RIGHTGAP=0.125000,
TOPGAP=0.013889,
BOTTOMGAP=0.027778,
$
TYPE=DATA,
ACROSSCOLUMN=N1,
FOCEXEC=TEST,
$
TYPE=TITLE,
STYLE=BOLD,
$
TYPE=TABHEADING,
SIZE=12,
STYLE=BOLD,
$
TYPE=TABFOOTING,
SIZE=12,
STYLE=BOLD,
$
TYPE=HEADING,
SIZE=12,
STYLE=BOLD,
$
TYPE=FOOTING,
SIZE=12,
STYLE=BOLD,
$
TYPE=SUBHEAD,
SIZE=10,
STYLE=BOLD,
$
TYPE=SUBFOOT,
SIZE=10,
STYLE=BOLD,
$
TYPE=SUBTOTAL,
BACKCOLOR=RGB(210 210 210),
$
TYPE=ACROSSVALUE,
SIZE=9,
$
TYPE=ACROSSTITLE,
STYLE=BOLD,
$
TYPE=GRANDTOTAL,
BACKCOLOR=RGB(210 210 210),
STYLE=BOLD,
$
ENDSTYLE
END


Hope this helps!
 
Posts: 55 | Registered: May 22, 2003Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     want to get rid of drill down on a total

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