[SOLVED] Drilldown in HTMTABLE

June 01, 2011, 04:48 AM

Hello,

is it possible to add a drilldown like this

$
-*TYPE=DATA,
-* 	COLUMN=N3,
-*    TARGET='neu',
-*	 DRILLMENUITEM='balbla',
-*     FOCEXEC=app/blabala( \
-*    blabal=blabla \
-*    ),

in output Format HTMTABLE

Christian

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

June 01, 2011, 05:23 AM

atturhari

Ya, Is it not working for you?

June 01, 2011, 05:31 AM

ChristianP

hi atturhari,

yes it is not working. that,s why i am asking!!

Christian

June 01, 2011, 05:50 AM

atturhari

What is not working for you?
Is the drilldown not being enabled on N3 or the values are not being passed to the drill report?

June 01, 2011, 06:10 AM

ChristianP

The column is marked as a drilldown (underline), but the link does not work. the IE7 shows in the left lower corner a error message (Line 1 Object expected) when i change the output format in HTML the drilldown works.

Christian

June 01, 2011, 06:41 AM

<JG>

Multidrill does not work as standard when you use HTMTABLE because it requires javascript that is not generated using that format.

If you want it then you must include the required javascript manually.

 TABLE FILE CAR
SUM
     COMPUTE SRC/A50 = 'buzzer01.jpg';
     COMPUTE IMAGE/A200 = '<img src="/approot/eacmgmex/' || SRC || '"  style="width:25px; height:25px;" >';
 AS ''
     DEALER_COST
     RETAIL_COST
BY COUNTRY
BY MODEL
BY CAR
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTMTABLE
ON TABLE SET STYLE *
$
TYPE=DATA,
     COLUMN=N1,
     DRILLMENUITEM='DrillDown 1',
          FOCEXEC=app/image,
     DRILLMENUITEM='DrillDown 2',
          FOCEXEC=app/image,
          TARGET='_blank',
$

ENDSTYLE
END
-RUN

-HTMLFORM BEGIN
<html>
<head>
<script language='javascript'>
var ibiOptions = new Array("multidrill");
var focexurl = "/ibi_apps/WFServlet?IBIF_webapp=/ibi_apps&|IBIC_server=EDASERVE&|IBIWF_msgviewer=OFF&|IBIAPP_app=appfolder&|IBIMR_drill=X,mredomain/mredomain.htm";
var fochtmlurl = "/ibi_html";
var serverLanguage='en';
</script>
<script language='javascript' src='/ibi_html/javaassist/nls.js'></script>
<script language='javascript' src='/ibi_html/javaassist/ibi/html/js/ibigbl.js'></script>
<script language='javascript'>
ibigblloadCss(null);
</script>
</head> 
!IBI.FIL.REPORT;
</html>
-HTMLFORM END

June 01, 2011, 06:56 AM

ChristianP

Hello J.G.

great!!!! Perfect!!!

Works fine!!!

Christian

June 06, 2011, 04:27 AM

ChristianP

Just a short question!!
how can i avoid the drilldown, when there is no data. we did this with a macro in html output. the macro in this case does not work.

-*     DEFMACRO=COND0001,
-*     MACTYPE=RULE,
-*     WHEN=N4 NE '',

Christian