Execute code after a PCHOLD FORMAT EXL2K

Focal Point

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/1397023476

January 16, 2015, 11:47 AM

Jonathan K.

Execute code after a PCHOLD FORMAT EXL2K

Is it possible to execute anything after a PCHOLD FORMAT EXL2K? I'm looking to run some HTML code with HTMLFORM but haven't had any success.

Example:

TABLE FILE CAR
PRINT *
ON TABLE PCHOLD FORMAT EXL2K
END

-HTMLFORM BEGIN
<script>
DO STUFF
</SCRIPT>
-HTMLFORM END

Thanks

This message has been edited. Last edited by: Jonathan K.,

January 16, 2015, 02:39 PM

Shakila Subhan

SET PAGE-NUM=NOLEAD

TABLE FILE CAR
SUM
SALES/D10 AS ''

BY COUNTRY
ACROSS MODEL AS ''

ON TABLE HOLD FORMAT HTMTABLE

ON TABLE SET STYLE *
UNITS=IN, SQUEEZE=ON, ORIENTATION=PORTRAIT, $
TYPE=REPORT, GRID=OFF, FONT='ARIAL', SIZE=9, $
TYPE=TITLE, STYLE=BOLD, $
TYPE=HEADING, STYLE=BOLD, HEADALIGN=BODY, $
TYPE=ACROSSVALUE, CLASS=headstyle, $
ENDSTYLE
END

SET HTMLFORMTYPE=XLS
-RUN

-HTMLFORM BEGIN
<style type="text/css">
.headstyle
{
mso-rotate:45;
vertical-align:bottom;
height:175;
}
</style>

!IBI.FIL.HOLD;
-HTMLFORM END

January 16, 2015, 06:38 PM

Jonathan K.

Thanks, I'll give it a try.

January 21, 2015, 12:26 PM

Jonathan K.

Shakila, unfortunately I wasn't able to get it to work with the code you provided. The scripts that I have do not execute within the HTMLFORM.

January 21, 2015, 03:21 PM

<FreSte>

I don't think you can do that combination in a single fex.

Maybe something like this ...

-Fred-

<html>
<body>

<iframe id='iframe1' src='/ibi_apps/WFServlet?IBIF_ex=car1'>
</iframe>

<script>
var _iframe = document.getElementById('iframe1');
_iframe.onload = function() {
	alert( 'done');
}
</script>

</body>
</html>

January 22, 2015, 02:59 PM

susannah

use a frameset
in 1 frame call one fex
in the other frame call the other fex.
or do it like a dashboard, use iframes