[CLOSED] HELP!! get report on iframe

July 21, 2014, 12:06 AM

Hi
, I have a mainpage.fex, that has two iframes, one dropdown and value change should run the report with car file.
one iframe has the dropdown and the other is empty.
I am not able to figure out to bring the result set into the empty frame2 in the below code.

----------------------------------------------------------------------

The following is the code in Mainpage.Fex

-------------------------------------------------------------------------



TABLE FILE CAR
SUM
COMPUTE OPT1/A200 = '<option value="' | COUNTRY | '">' | COUNTRY | '</option>';
BY COUNTRY NOPRINT
ON TABLE SAVE AS S001
END
-RUN

-HTMLFORM BEGIN

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN"
"http://www.w3.org/TR/html4/strict.dtd">
<HTML>
<HEAD>
<META id=RLT_STANDARDS_MODE_META content=IE=9 http-equiv=X-UA-Compatible>
<META name=mycharsetmeta content="text/html; charset=ISO-8859-1" http-equiv=Content-Type>
<META name=Generation content="Created in release 8005, Generation 3">
<SCRIPT type=text/javascript>
</SCRIPT>

<!-- The following code is to detect Ipad and Iphone and see if you can set screen size here -->
<script type="text/javascript">
if (navigator.userAgent.match(/iPhone/i) || navigator.userAgent.match(/iPad/i)) {
    var viewportmeta = document.querySelector('meta[name="viewport"]');
    if (viewportmeta) {
        viewportmeta.content = 'width=device-width, minimum-scale=1.0, maximum-scale=1.0, initial-scale=1.0';
        document.body.addEventListener('gesturestart', function () {
            viewportmeta.content = 'width=device-width, minimum-scale=0.25, maximum-scale=1.6';
        }, false);
    }
}
</script>

<script type="text/javascript">
function selectCountry()
{
for (var i = 0; i < document.forms[0].COUNTRY.length; i++)
  {
  if (document.forms[0].COUNTRY[i].value == '!IBI.AMP.COUNTRY;')
    {
     document.forms[0].COUNTRY.selectedIndex = i;
     break;
    }
  }

}
</script>

<style type="text/css">

div {
    width: 260px;
	height: 44px;
    overflow: hidden;
    border: none;
    padding: 20px 20px 10px 10px;
    -webkit-appearance: none;
 position:absolute;

}
select {
    width: 300px;
    border: 0px;
	height: 44px;
    font: normal 14px/16px "HelveticaNeueLTCom45Light" , Georgia,serif;

    float: none;
    background-color: #9a8b7d;

    -webkit-appearance: none;
}


</style>
</HEAD>
<BODY onload="selectCountry();">

<form action="/ibi_apps/WFServlet" method="get">

<input type="hidden" name="IBIF_ex"  value="manual_run1.fex"  sourcetype="typeFex" targettype="iframe" targetname="frame2"  >

<div>
<select name="COUNTRY" id ="drop1" onchange="document.forms[0].submit();">
  !IBI.FIL.S001;
</select>
</div>
 <iframe  id = "frame1" name = "frame1" style="Z-INDEX: 2;  WIDTH: 350px; HEIGHT: 900px; TOP: 0px; LEFT: 0px;  ">
 </iframe>
<iframe   id = "frame2" name = "frame2" style="Z-INDEX: 3; WIDTH: 750px; HEIGHT: 900px; TOP: 0px; LEFT: 350px ;   ">
</iframe>



</form>



</BODY>


</HTML>

 -HTMLFORM END

----------------------------------------------------------------------

The following is the code in manual_run1.fex.
-------------------------------------------------------------------------


-SET &ECHO='ALL';

SET HOLDLIST=PRINTONLY
SET HOLDFORMAT=ALPHA
-RUN

-DEFAULT &COUNTRY = 'ENGLAND';

-*-- Prepare report

TABLE FILE CAR
SUM
SALES
BY COUNTRY
WHERE COUNTRY EQ '&COUNTRY';
ON TABLE SET PAGE NOLEAD
ON TABLE HOLD AS R001 FORMAT HTMTABLE
END
-RUN

-HTMLFORM BEGIN
<html>
!IBI.FIL.R001;
</html>
-HTMLFORM END

This message has been edited. Last edited by: <Kathryn Henning>,