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,

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

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.

Thanks.