I'm having trouble getting a multiple drilldown working in a HTM page. I'm doing some processing in a HOLD file then hold the formatted data in FORMAT HTMTABLE. I grab this hold file from the HTM file using < !--WEBFOCUS TABLE HLDRPT>. If I take out the multiple drilldown and leave one drill the page works.

FEX Code:

TABLE FILE CAR
PRINT
CAR
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
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,
COLUMN=N1,
DRILLMENUITEM='Trend 1',
FOCEXEC=trenda(a=N1),
DRILLMENUITEM='Trend 2',
FOCEXEC=trendb(b=N1 c=N1),
DRILLMENUITEM='Trend 3',
FOCEXEC=trendc(d=N1 e=N1 f=N1),
$
ENDSTYLE
ON TABLE HOLD AS HLDRPT FORMAT HTMTABLE
END
-SET &REPORTNAME = 'Test MDrill';
-HTMLFORM test.htm
HTM Code:







< !--WEBFOCUS TABLE HLDRPT>

This message has been edited. Last edited by: <Mabel>,

yep
here's the magic bullet answer
ON TABLE HOLD AS whatever FORMAT HTML
oh, and also you can just drop an &var into the title tag directly

 <br /><TITLE><br />&REPORTNAME<br /><TITLE> 

whole lot easier. (I had never seen that WEBFOCUS VAR version...thanks for sharing that.)
and take that </table> tag out. you don't need it.

Susannah has a point - run the report in HTML hold format.

Do a view source.

See the code in the head section of the HTML? Those JavaScript includes? You need them.

HTMTABLE doesn't generate a head section - it was designed to only output a table body so it could be included in an HTML template of your design.

Clipboard that HEAD section and paste it into your home-baked template and multi-drill will work. You can keep your custom TITLE tag.

Try it out. There ya go. You're home.

Thanks Susannah & Bob Jude Ferrante. That worked. </table> tag was leftovers I forgot to remove for whipping up this sample code together.

One last question. Does this method work for using graphs in a HTML page? Such as saving the graph in FORMAT GIF and referencing it by the hold name.