March 27, 2007, 11:17 AM
gwellerMultiple actions on single drilldown
I have an HTML Compound report with three linked focexecs;
- One is a bar graph that shows a monthly trend of daily letters completed.
- The second is a pie chart that breaks out the report by letter type for the current day
- Lastly there is a detail report for the current days completed letters
Here is what I would like to be able to do.
I would like to be able to drill down on the bar graph to be able to switch between days within the trend period. This should then update both the detail report and the pie chart.
I would also like to be able to drilldown on the pie chart (by letter type) and update both the details report and trend chart to show detail for only that letter type.
I have been rather unsuccessful in getting webFOCUS to be able to do multiple actions within the same drilldown. I have read other suggestions to do some fancy coding and combine two of the fex's into one, however I would like the three to act independently for the reusablity factor.
Thanks in advance
March 27, 2007, 11:43 AM
Tony AQweller,
You can drilldown to a javascript function where you could modify the location strings of the various components (I guess you are using iframes?). This would enable you to update all three items from just the single drilldown.
T
March 27, 2007, 01:12 PM
gwellerThanks Tony,
For some reason that never crossed my mind. It works well.
Here is a code snip for future reference...
TYPE=DATA,
ACROSSCOLUMN=N1,
JAVASCRIPT=testThis(A1),
ALT='Click to view letters completed for this date',
$
As a side note I am having an issue setting the src of the iframe once in the function. Here is my code..
document.getElementById("report1").src = "Controller?WORP_MPV=aj_mpv&WORP_REQUEST_TYPE=WORP_LAUNCH_CGI&IBIMR_action=MR_RUN_FEX&IBIMR_sub_action=MR_STD_REPORT&IBIMR_flags=&IBIMR_domain=DOMAINNAME&IBIMR_folder=%23clientletter&IBIF_ex=app%2Fnewproce.fex&IBIMR_fex=app%2Fnewproce.fex&STARTDATE=20070131";}
It calls the fex ok, but it does not recognize the parameter being passed. If I place this same function outside the MRE it works fine...
Any further ideas?
Thanks
March 27, 2007, 02:49 PM
Tony Agweller,
Works fine for me when in Iframes on a parent HTML page -
ON TABLE SET STYLE *
TYPE=DATA, COLUMN=COUNTRY, JAVASCRIPT=parent.reload(COUNTRY), $
ENDSTYLE
and HTML code -
<html>
<head>
<title>Javascript Drilldown</title>
</head>
<script language=javascript>
function reload(Country) {
document.getElementById("iframe1").src
="http://localhost/cgi-bin/ibi_cgi/ibiweb.exe?IBIAPP_app=focalpoint&IBIF_ex=js_report1.fex&Country="+Country;
}
</script>
<body>
<iframe name=iframe1 id=iframe1 style="position:absolute; top:50px; left:50px; width:450px; height:300px;"
src="http://localhost/cgi-bin/ibi_cgi/ibiweb.exe?IBIAPP_app=focalpoint&IBIF_ex=js_report1.fex">
<iframe name=iframe2 id=iframe2 style="position:absolute; top:50px; left:520px; width:450px; height:300px;"
src="http://localhost/cgi-bin/ibi_cgi/ibiweb.exe?IBIAPP_app=focalpoint&IBIF_ex=js_report2.fex">
<iframe name=iframe3 id=iframe3 style="position:absolute; top:370px; left:50px; width:920px; height:300px;"
src="http://localhost/cgi-bin/ibi_cgi/ibiweb.exe?IBIAPP_app=focalpoint&IBIF_ex=js_report3.fex">
</body>
</html>
T
March 27, 2007, 04:14 PM
gwellerThanks for the follow up Tony, I actually had just figured it out by cheating a little bit...
I put the drilldown back in via the focexec and looked at what was being passed by the system... altered it a little and this is what I came up with....
document.getElementById("report1").src = "WFServlet?IBIF_webapp=%2Fibi_apps&IBIC_server=EDASERVE&IBIWF_msgviewer=OFF&&IBIMR_drill=X,DOMAINNAME&IBIF_ex=app%2Fdailycli.fex&CLICKED_ON=UNSET%20PARAMETER&START_DATE=" + s + "&"
Works like a charm.......
Thanks
gweller