[SOLVED] Multiple drilldown in Excel

I have a multiple drill down on a column title.
In html if you click on the title it gives you two drill downs to choose from.
In excel it does not give you the multiple list’s to choose from you click and it opens the first drill down.
See code below.
-* File car.fex
TABLE FILE CAR
SUM
DEALER_COST OVER
RETAIL_COST
HEADING
""
FOOTING
""
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT &WFFMT.(,,,,,).Select type of display output.
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='ARIAL',
SIZE=9,
$
TYPE=TITLE,
STYLE=BOLD,
$
TYPE=TITLE,
COLUMN=N1,
TARGET='_blank',
DRILLMENUITEM='CAR1',
FOCEXEC=car1,
DRILLMENUITEM='CAR2',
FOCEXEC=car2,
$
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

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

WebFOCUS Dev Studio 8105m

Posts: 24 | Registered: September 24, 2007

GinnyJakes

Expert

posted

Hide Post

As the documentation states, DRILLMENUITEM is only supported for reports in HTML and HTMTABLE formats.

Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google

Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006

Ignored post by GinnyJakes posted

Show Post

susannah

Expert

posted

Hide Post

as Ginny says,
DRILLMENU item is accomplished with Javascript.
Javascript works in a browser
Excel is not a browser,
and (my personal favorite mantra) Outlook is not a browser (but its getting close!)
So these 2 formats drop all but the first item in the list.
When i send a report via outlook, with alot of multidrills...i disable all the drilldowns except one, in the heading, which says
'click here for live version'...and that click reruns the fex, bringing it back in the browser, and your mulidrills work.