As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at firstname.lastname@example.org and provide your corporate email address, company, and name.
Might I say that you're jumping around this problem like a proverbial ####### (your choice of phrase here )
If we get back to what you are trying to do overall, would the following be true?
You need to output two similar reports, work orders and customer orders, with the ability to drill to a sub report in a choice of formats - HTML and PDF.
The simple way to move forward to encompass the solutions to the individual "challenges" would be to HOLD FORMAT HTMTABLE (not PCHOLD HTML) the reports and then stitch them together using an HTMLFORM. By using HTMTABLE you are effectively stripping off the outer HTML "glue" and therefore you will have to remedy that yourself in the HTMLFORM.
With your existing code, HOLD the two reports FORMAT HTMTABLE AS HTML1 and HTML2 and then consider this code to stitch them together (change the IBIAPP_app=focalpoint to your app folder) -
<title>Tomsweb Two Reports</title>
var ibiOptions = new Array("multidrill");
var focexurl = "/ibi_apps/WFServlet?IBIF_webapp=/ibi_apps&|IBIC_server=EDASERVE&|IBIWF_msgviewer=OFF&|IBIAPP_app=focalpoint&";
var fochtmlurl = "/ibi_html";
Just so that you do not think this is me "waving my magic wand" (keep it clean at the back!!), I grabbed the "outer" scripting requirement by first running one of the reports PCHOLD FORMAT HTML to use in the HTMLFORM. I also used the fact that, by having the files as HTMTABLE output, the MDItem array would be correctly created across both outputs.
If you want to go one step further and add hover text, then it's a simpleprocess of adding some JQuery into the mix.
In FOCUS since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2
WebFOCUS App Studio 8.2.06 standalone on Windows 10
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004