I realized the other day that the multi-drill functionality simply didn't work when your output was to HTMTABLE. If you try it, you get a hyperlink, but when you click on it, nothing happens other than a javascript error. I thought "this has to just be a javascript problem". So by comparing a working version of HTML output vs. a non-working version of HTMTABLE output, I noticed some specific differences in the javascript that was being included at the top of the output. When I included those differences in an HTMLFORM in my report output, viola, the multi-drill functionality suddenly worked again!

Please note, this code assumes you're running in MRE and I have not tested this against any browser except IE. One thing to be aware of is that the MRE domain html file is in part of this code, so you'll need to tweak it to reference the appropriate file in your environment.

This example assumes that somewhere in your fex, you are holding your output as an HTMTABLE such as the following example:

ON TABLE HOLD AS EXPBYGRD FORMAT HTMTABLE

Then at the bottom of your fex, you'll need to include these lines in your HTMLFORM code:

-HTMLFORM BEGIN
<script language='javascript'>
var ibiOptions = new Array("multidrill");
-*had to separate out this line to deal with the ampers -- also, tweak your domain htm file here.
var focexurl = "/ibi_apps/WFServlet?IBIF_webapp=/ibi_apps" + "&" + "IBIC_server=EDASERVE" + "&" + 
               "IBIWF_msgviewer=OFF" + "&" + "&" + "IBIMR_drill=X,developm/developm.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>
-*the following lines are your report files that you've held
-*these need to be set to whatever report hold files you generated as in the example above
!IBI.FIL.T10INV;
!IBI.FIL.T10SPC;
!IBI.FIL.EXPBYGRD;
-HTMLFORM END

That's all there is to it -- hope that helps someone!

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

ON TABLE HOLD FORMAT HTML
not HTMTABLE
works like a charm.

Yes, that's what Trav also said.
Point is, that sometimes you need to have more than 1 report in your htm page, and then HOLD as HTMTABLE comes into play.
Thanks Trav, for working this out, it may prevent some serious headaches here and there.

Yes, HTML definitely still works just fine -- this is solely a solution to it not working with the HTMTABLE output. I'm not sure how & when other people are using the HTMTABLE output, but the most obvious reason is as GamP mentioned when you have multiple reports that you need to display in a single output frame. If you use HTMTABLE then you don't totally mess up the styling of the reports. Otherwise, if you CAN use HTML, then def. use it.

Thanks Trav. This was just the piece of code that I needed.

Paul

Glad I could help!

Just ran into this issue and your solution worked perfectly! Thank you for posting this!

I've spent the past 2 hours trying to figure out this same issue.

Both of your solutions work, thanks for the find!