March 29, 2012, 03:31 PM
MrMProblems with using parameters
I got an issue with starting an application made in the HTML composer.
What I have to make is that web1 has to start using an URL and than thru a drilldown starting web2 with given parameters.
The problem is that the first web1 doesn't receive parameter &NAM and the second web2 doesn't receive parameters &NAM and &COUNTRY.
What can I do to make this work?
Used URL:
http://localhost:8080/approot/...web1.htm?&NAM=PersonHere by the source
source Web1
<!-- Generated by Report Layout Painter -->
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<HTML>
<HEAD>
<META id=mycharsetmeta content="text/html; charset=ISO-8859-1" http-equiv=Content-Type>
<META id=Generation content="Created in release 7701, Generation 3.0">
<SCRIPT id=IBI_RelCallBack type=text/javascript>function AdjustChildrenPosition(){
}
</SCRIPT>
<SCRIPT id=IBI_OptionsScript type=text/javascript>
var cgipath = "cgipath";
var ibirls = "ibirls3";
var rltdyncalendar = "rltdyncalendar";
var gmap = "ibigmap";
var olap="olap";
var olappanebase="olappanebase";
var olapdrill="olapdrill";
var ibixmltree="ibixmltree";
var ibiOptions = new Array(cgipath,ibirls);
</SCRIPT>
<SCRIPT id=IBI_nls type=text/javascript src="/ibi_html/javaassist/nls.js"></SCRIPT>
<SCRIPT id=IBI_nlsVars type=text/javascript src="/ibi_html/javaassist/nlsvars.js"></SCRIPT>
<SCRIPT id=IBI_ibigbl type=text/javascript src="/ibi_html/javaassist/ibi/html/js/ibigbl.js"></SCRIPT>
<SCRIPT id=IBI_ibigblloadCss type=text/javascript>
ibigblloadCss(null);
addIntlTranslatedJS("composertrans.js");
</SCRIPT>
<TITLE>HtmlPage</TITLE>
<SCRIPT id=clientEventHandlersJS type=text/javascript>
//Begin function window_onload
function window_onload() {
UpdateData();
// TODO: Add your event handler code here
//add onInitialUpdate() function to make changes before initial run of the reports
}
//End function window_onload
</SCRIPT>
<SCRIPT for=window type=text/javascript eventname="onload">window.onload = function() { window_onload(); }</SCRIPT>
<STYLE id=ibi_defaultstyleElt type=text/css>.tabitemsclass {
BACKGROUND-COLOR: white
}
</STYLE>
</HEAD>
<BODY style="OVERFLOW: auto" edaconnectionrequired="true" elementtype="21" thumbnailscale="4">
<SPAN style="Z-INDEX: 2; POSITION: absolute; WIDTH: 1270px; HEIGHT: 740px; TOP: 70px; LEFT: 50px" id=tab1 tabIndex=2 elementtype="38" tabitemsdefaultdist="5" tablocation="top" tabitemsdefaultwidth="100" tabitemsdefaultheight="25" tabedgerounded="straight">
<SPAN style="Z-INDEX: 5; BORDER-BOTTOM: white thin; POSITION: absolute; TEXT-ALIGN: center; BORDER-LEFT: teal 1px solid; WRITING-MODE: lr-tb; WIDTH: 100px; HEIGHT: 26px; BORDER-TOP: gold 3px solid; CURSOR: pointer; BORDER-RIGHT: teal 1px solid; TOP: 0px; LEFT: 15px" id=tabitem1 class=tabitemsclass tabIndex=3 elementtype="39" tabbody="tabitembody1" selectedtab="true">Tab #1</SPAN>
<SPAN style="Z-INDEX: 4; BORDER-BOTTOM: teal 1px solid; POSITION: absolute; BORDER-LEFT: teal 1px solid; WIDTH: 1270px; DISPLAY: block; HEIGHT: 715px; BORDER-TOP: teal 1px solid; BORDER-RIGHT: teal 1px solid; TOP: 25px; LEFT: 0px" id=tabitembody1 class=tabitemsclass tabIndex=4 elementtype="40">
<IFRAME style="Z-INDEX: 6; POSITION: absolute; WIDTH: 630px; HEIGHT: 660px; OVERFLOW: auto; TOP: 15px; LEFT: 50px" id=report1 tabIndex=7 src="" frameBorder=no elementtype="2" HEIGHTOLD="660" WIDTHOLD="630" autoExecute="True" requests_list="0" name="report1"></IFRAME></SPAN>
<SPAN style="Z-INDEX: 3; BORDER-BOTTOM: white thin; POSITION: absolute; TEXT-ALIGN: center; BORDER-LEFT: teal 1px solid; WRITING-MODE: lr-tb; WIDTH: 100px; HEIGHT: 22px; BORDER-TOP: teal 1px solid; CURSOR: pointer; BORDER-RIGHT: teal 1px solid; TOP: 3px; LEFT: 120px" id=tabitem2 class=tabitemsclass tabIndex=5 elementtype="39" tabbody="tabitembody2" selectedtab="false">Tab #2</SPAN>
<SPAN style="Z-INDEX: 2; BORDER-BOTTOM: teal 1px solid; POSITION: absolute; BORDER-LEFT: teal 1px solid; WIDTH: 1270px; DISPLAY: none; HEIGHT: 715px; BORDER-TOP: teal 1px solid; BORDER-RIGHT: teal 1px solid; TOP: 25px; LEFT: 0px" id=tabitembody2 class=tabitemsclass tabIndex=6 elementtype="40"></SPAN></SPAN>
<INPUT style="POSITION: absolute; TOP: -100px; LEFT: -100px" id=layoutinfo type=hidden tabcontrolids="tab1">
<INPUT style="POSITION: absolute; TOP: -100px; LEFT: -100px" id=ibiapp_app value=webpag type=hidden name="ibiapp_app">
<INPUT style="POSITION: absolute; TOP: -100px; LEFT: -100px" id=ibic_server value=EDASERVE type=hidden isdataserversarea="1" name="ibic_server">
<xml id=focus_xmlelement>
<script type="text/xml">
<rootxmlnode focoption="_FOC_NULL">
<variables>
<variable controltype="7" parametercreatedinreslay="0" type="default" desc="NAM" name="NAM" default=" " textvarname="" accept="0" select="0" create="0">
<link linktype="default">
<condition default="1" name="Default" whattodowithcontrol="4" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0">
<data_info checkForDuplicateValues="0" displayfield="NAM" datafield="NAM" datasource="car.mas" datatype="0" selectedvalue=" " operation="" slider_range_from="" slider_range_to="">
<static_values>
<static value=" " display=" " selected="1" noinput="0"></static></static_values></data_info></condition></link>
<requestid id="0"></requestid></variable></variables>
<input_controls></input_controls>
<other_bound_objects></other_bound_objects>
<requests nextrequestsid="0">
<request requestid="0" targetname="report1" ibif_ex="report1" targettype="iframe" sourcetype="typeAdhocfex" activereport="0">
<![CDATA[-* File fex1.fex
-SET &ECHO=ALL;
-DEFAULT &NAM = '';
TABLE FILE CAR
PRINT
'CAR.ORIGIN.COUNTRY'
'CAR.COMP.CAR'
'CAR.CARREC.MODEL'
HEADING
"Name : &NAM"
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = endeflt,
$
TYPE=DATA,
COLUMN=N1,
TARGET='_parent',
URL=http://localhost:8080/approot/webpag/web2.htm?( \
COUNTRY=N1 \
NAM=&NAM.QUOTEDSTRING \
),
$
ENDSTYLE
END]]></request></requests></rootxmlnode></script>
</xml></BODY>
<SCRIPT id=IBI_loader type=text/javascript>
doBeforeLoad();
</SCRIPT>
</HTML>
source Web2
<!-- Generated by Report Layout Painter -->
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<HTML>
<HEAD>
<META id=mycharsetmeta content="text/html; charset=ISO-8859-1" http-equiv=Content-Type>
<META id=Generation content="Created in release 7701, Generation 3.0">
<SCRIPT id=IBI_RelCallBack type=text/javascript>function AdjustChildrenPosition(){
}
</SCRIPT>
<SCRIPT id=IBI_OptionsScript type=text/javascript>
var cgipath = "cgipath";
var ibirls = "ibirls3";
var rltdyncalendar = "rltdyncalendar";
var gmap = "ibigmap";
var olap="olap";
var olappanebase="olappanebase";
var olapdrill="olapdrill";
var ibixmltree="ibixmltree";
var ibiOptions = new Array(cgipath,ibirls);
</SCRIPT>
<SCRIPT id=IBI_nls type=text/javascript src="/ibi_html/javaassist/nls.js"></SCRIPT>
<SCRIPT id=IBI_nlsVars type=text/javascript src="/ibi_html/javaassist/nlsvars.js"></SCRIPT>
<SCRIPT id=IBI_ibigbl type=text/javascript src="/ibi_html/javaassist/ibi/html/js/ibigbl.js"></SCRIPT>
<SCRIPT id=IBI_ibigblloadCss type=text/javascript>
ibigblloadCss(null);
addIntlTranslatedJS("composertrans.js");
</SCRIPT>
<TITLE>HtmlPage</TITLE>
<SCRIPT id=clientEventHandlersJS type=text/javascript>
//Begin function window_onload
function window_onload() {
UpdateData();
// TODO: Add your event handler code here
//add onInitialUpdate() function to make changes before initial run of the reports
}
//End function window_onload
</SCRIPT>
<SCRIPT for=window type=text/javascript eventname="onload">window.onload = function() { window_onload(); }</SCRIPT>
</HEAD>
<BODY style="OVERFLOW: auto" edaconnectionrequired="true" elementtype="21" thumbnailscale="4">
<IFRAME style="Z-INDEX: 1; POSITION: absolute; WIDTH: 560px; HEIGHT: 770px; OVERFLOW: auto; TOP: 20px; LEFT: 30px" id=report1 tabIndex=1 src="" frameBorder=no elementtype="2" HEIGHTOLD="770" WIDTHOLD="560" autoExecute="True" requests_list="0" name="report1"></IFRAME>
<INPUT style="POSITION: absolute; TOP: -100px; LEFT: -100px" id=layoutinfo type=hidden>
<INPUT style="POSITION: absolute; TOP: -100px; LEFT: -100px" id=ibiapp_app value=webpag type=hidden name="ibiapp_app">
<INPUT style="POSITION: absolute; TOP: -100px; LEFT: -100px" id=ibic_server value=EDASERVE type=hidden isdataserversarea="1" name="ibic_server">
<xml id=focus_xmlelement>
<script type="text/xml">
<rootxmlnode focoption="_FOC_NULL">
<variables>
<variable controltype="7" parametercreatedinreslay="0" type="default" desc="COUNTRY" name="COUNTRY" default=" " textvarname="" accept="0" select="0" create="0">
<link linktype="default">
<condition default="1" name="Default" whattodowithcontrol="4" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0">
<data_info checkForDuplicateValues="0" displayfield="COUNTRY" ibiformat="A10" datafield="COUNTRY" datasource="car.mas" datatype="0" selectedvalue=" " operation="" slider_range_from="" slider_range_to="">
<static_values>
<static value=" " display=" " selected="1" noinput="0"></static></static_values></data_info></condition></link>
<requestid id="0"></requestid></variable>
<variable controltype="7" parametercreatedinreslay="0" type="default" desc="NAM" name="NAM" default=" " textvarname="" accept="0" select="0" create="0">
<link linktype="default">
<condition default="1" name="Default" whattodowithcontrol="4" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0">
<data_info checkForDuplicateValues="0" displayfield="NAM" datafield="NAM" datasource="car.mas" datatype="0" selectedvalue=" " operation="" slider_range_from="" slider_range_to="">
<static_values>
<static value=" " display=" " selected="1" noinput="0"></static></static_values></data_info></condition></link>
<requestid id="0"></requestid></variable></variables>
<input_controls></input_controls>
<other_bound_objects></other_bound_objects>
<requests nextrequestsid="0">
<request requestid="0" targetname="report1" ibif_ex="report1" targettype="iframe" sourcetype="typeAdhocfex" activereport="0">
<![CDATA[-* File fex2.fex
-SET &ECHO=ALL;
-DEFAULT &COUNTRY = '';
-DEFAULT &NAM = '';
TABLE FILE CAR
PRINT
'CAR.ORIGIN.COUNTRY'
'CAR.COMP.CAR'
'CAR.CARREC.MODEL'
WHERE CAR.ORIGIN.COUNTRY = '&COUNTRY'
HEADING
"Name : &NAM"
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = endeflt,
$
ENDSTYLE
END]]></request></requests></rootxmlnode></script>
</xml></BODY>
<SCRIPT id=IBI_loader type=text/javascript>
doBeforeLoad();
</SCRIPT>
</HTML>
March 29, 2012, 06:14 PM
Francis MarianiYou can't pass parameter values via a HTML page URL, without having to resort to complicated JavaScript. A much easier way is to call a fex that includes the HTML page. I created to fexes and made minor tweaks to the HTML and now parameters are passed.
web1.fex
-DEFAULT &NAM = 'Default Name 1';
-HTMLFORM web1.htm
web1.htm
<!-- Generated by Report Layout Painter -->
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<HTML>
<HEAD>
<META id=mycharsetmeta content="text/html; charset=ISO-8859-1" http-equiv=Content-Type>
<META id=Generation content="Created in release 7701, Generation 3.0">
<SCRIPT id=IBI_RelCallBack type=text/javascript>function AdjustChildrenPosition(){
}
</SCRIPT>
<SCRIPT id=IBI_OptionsScript type=text/javascript>
var cgipath = "cgipath";
var ibirls = "ibirls3";
var rltdyncalendar = "rltdyncalendar";
var gmap = "ibigmap";
var olap="olap";
var olappanebase="olappanebase";
var olapdrill="olapdrill";
var ibixmltree="ibixmltree";
var ibiOptions = new Array(cgipath,ibirls);
</SCRIPT>
<SCRIPT id=IBI_nls type=text/javascript src="/ibi_html/javaassist/nls.js"></SCRIPT>
<SCRIPT id=IBI_nlsVars type=text/javascript src="/ibi_html/javaassist/nlsvars.js"></SCRIPT>
<SCRIPT id=IBI_ibigbl type=text/javascript src="/ibi_html/javaassist/ibi/html/js/ibigbl.js"></SCRIPT>
<SCRIPT id=IBI_ibigblloadCss type=text/javascript>
ibigblloadCss(null);
addIntlTranslatedJS("composertrans.js");
</SCRIPT>
<TITLE>HtmlPage</TITLE>
<SCRIPT id=clientEventHandlersJS type=text/javascript>
//Begin function window_onload
function window_onload() {
UpdateData();
// TODO: Add your event handler code here
//add onInitialUpdate() function to make changes before initial run of the reports
}
//End function window_onload
</SCRIPT>
<SCRIPT for=window type=text/javascript eventname="onload">window.onload = function() { window_onload(); }</SCRIPT>
<STYLE id=ibi_defaultstyleElt type=text/css>.tabitemsclass {
BACKGROUND-COLOR: white
}
</STYLE>
</HEAD>
<BODY style="OVERFLOW: auto" edaconnectionrequired="true" elementtype="21" thumbnailscale="4">
<SPAN style="Z-INDEX: 2; POSITION: absolute; WIDTH: 1270px; HEIGHT: 740px; TOP: 70px; LEFT: 50px" id=tab1 tabIndex=2 elementtype="38" tabitemsdefaultdist="5" tablocation="top" tabitemsdefaultwidth="100" tabitemsdefaultheight="25" tabedgerounded="straight">
<SPAN style="Z-INDEX: 5; BORDER-BOTTOM: white thin; POSITION: absolute; TEXT-ALIGN: center; BORDER-LEFT: teal 1px solid; WRITING-MODE: lr-tb; WIDTH: 100px; HEIGHT: 26px; BORDER-TOP: gold 3px solid; CURSOR: pointer; BORDER-RIGHT: teal 1px solid; TOP: 0px; LEFT: 15px" id=tabitem1 class=tabitemsclass tabIndex=3 elementtype="39" tabbody="tabitembody1" selectedtab="true">Tab #1</SPAN>
<SPAN style="Z-INDEX: 4; BORDER-BOTTOM: teal 1px solid; POSITION: absolute; BORDER-LEFT: teal 1px solid; WIDTH: 1270px; DISPLAY: block; HEIGHT: 715px; BORDER-TOP: teal 1px solid; BORDER-RIGHT: teal 1px solid; TOP: 25px; LEFT: 0px" id=tabitembody1 class=tabitemsclass tabIndex=4 elementtype="40">
<IFRAME style="Z-INDEX: 6; POSITION: absolute; WIDTH: 630px; HEIGHT: 660px; OVERFLOW: auto; TOP: 15px; LEFT: 50px" id=report1 tabIndex=7 src="" frameBorder=no elementtype="2" HEIGHTOLD="660" WIDTHOLD="630" autoExecute="True" requests_list="0" name="report1"></IFRAME></SPAN>
<SPAN style="Z-INDEX: 3; BORDER-BOTTOM: white thin; POSITION: absolute; TEXT-ALIGN: center; BORDER-LEFT: teal 1px solid; WRITING-MODE: lr-tb; WIDTH: 100px; HEIGHT: 22px; BORDER-TOP: teal 1px solid; CURSOR: pointer; BORDER-RIGHT: teal 1px solid; TOP: 3px; LEFT: 120px" id=tabitem2 class=tabitemsclass tabIndex=5 elementtype="39" tabbody="tabitembody2" selectedtab="false">Tab #2</SPAN>
<SPAN style="Z-INDEX: 2; BORDER-BOTTOM: teal 1px solid; POSITION: absolute; BORDER-LEFT: teal 1px solid; WIDTH: 1270px; DISPLAY: none; HEIGHT: 715px; BORDER-TOP: teal 1px solid; BORDER-RIGHT: teal 1px solid; TOP: 25px; LEFT: 0px" id=tabitembody2 class=tabitemsclass tabIndex=6 elementtype="40"></SPAN></SPAN>
<INPUT style="POSITION: absolute; TOP: -100px; LEFT: -100px" id=layoutinfo type=hidden tabcontrolids="tab1">
<INPUT style="POSITION: absolute; TOP: -100px; LEFT: -100px" id=ibiapp_app value=webpag type=hidden name="ibiapp_app">
<INPUT style="POSITION: absolute; TOP: -100px; LEFT: -100px" id=ibic_server value=EDASERVE type=hidden isdataserversarea="1" name="ibic_server">
<xml id=focus_xmlelement>
<script type="text/xml">
<rootxmlnode focoption="_FOC_NULL">
<variables>
<variable controltype="7" parametercreatedinreslay="0" type="default" desc="NAM" name="NAM" default=" " textvarname="" accept="0" select="0" create="0">
<link linktype="default">
<condition default="1" name="Default" whattodowithcontrol="4" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0">
<data_info checkForDuplicateValues="0" displayfield="NAM" datafield="NAM" datasource="car.mas" datatype="0" selectedvalue=" " operation="" slider_range_from="" slider_range_to="">
<static_values>
<static value=" " display=" " selected="1" noinput="0"></static></static_values></data_info></condition></link>
<requestid id="0"></requestid></variable></variables>
<input_controls></input_controls>
<other_bound_objects></other_bound_objects>
<requests nextrequestsid="0">
<request requestid="0" targetname="report1" ibif_ex="report1" targettype="iframe" sourcetype="typeAdhocfex" activereport="0">
<![CDATA[-* File fex1.fex
-SET &ECHO=ALL;
-SET &NAM = '!IBI.AMP.NAM;';
TABLE FILE CAR
PRINT
'CAR.ORIGIN.COUNTRY'
'CAR.COMP.CAR'
'CAR.CARREC.MODEL'
HEADING
"Name : &NAM"
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = endeflt,
$
TYPE=DATA,
COLUMN=N1,
TARGET='_parent',
FOCEXEC=web2.fex ( \
COUNTRY=N1 \
NAM=&NAM.QUOTEDSTRING \
),
$
ENDSTYLE
END]]></request></requests></rootxmlnode></script>
</xml></BODY>
<SCRIPT id=IBI_loader type=text/javascript>
doBeforeLoad();
</SCRIPT>
</HTML>
web2.fex
-DEFAULT &COUNTRY = 'FRANCE';
-DEFAULT &NAM = 'Default Name 2';
-HTMLFORM web2.htm
web2.htm
<!-- Generated by Report Layout Painter -->
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<HTML>
<HEAD>
<META id=mycharsetmeta content="text/html; charset=ISO-8859-1" http-equiv=Content-Type>
<META id=Generation content="Created in release 7701, Generation 3.0">
<SCRIPT id=IBI_RelCallBack type=text/javascript>function AdjustChildrenPosition(){
}
</SCRIPT>
<SCRIPT id=IBI_OptionsScript type=text/javascript>
var cgipath = "cgipath";
var ibirls = "ibirls3";
var rltdyncalendar = "rltdyncalendar";
var gmap = "ibigmap";
var olap="olap";
var olappanebase="olappanebase";
var olapdrill="olapdrill";
var ibixmltree="ibixmltree";
var ibiOptions = new Array(cgipath,ibirls);
</SCRIPT>
<SCRIPT id=IBI_nls type=text/javascript src="/ibi_html/javaassist/nls.js"></SCRIPT>
<SCRIPT id=IBI_nlsVars type=text/javascript src="/ibi_html/javaassist/nlsvars.js"></SCRIPT>
<SCRIPT id=IBI_ibigbl type=text/javascript src="/ibi_html/javaassist/ibi/html/js/ibigbl.js"></SCRIPT>
<SCRIPT id=IBI_ibigblloadCss type=text/javascript>
ibigblloadCss(null);
addIntlTranslatedJS("composertrans.js");
</SCRIPT>
<TITLE>HtmlPage</TITLE>
<SCRIPT id=clientEventHandlersJS type=text/javascript>
//Begin function window_onload
function window_onload() {
UpdateData();
// TODO: Add your event handler code here
//add onInitialUpdate() function to make changes before initial run of the reports
}
//End function window_onload
</SCRIPT>
<SCRIPT for=window type=text/javascript eventname="onload">window.onload = function() { window_onload(); }</SCRIPT>
</HEAD>
<BODY style="OVERFLOW: auto" edaconnectionrequired="true" elementtype="21" thumbnailscale="4">
<IFRAME style="Z-INDEX: 1; POSITION: absolute; WIDTH: 560px; HEIGHT: 770px; OVERFLOW: auto; TOP: 20px; LEFT: 30px" id=report1 tabIndex=1 src="" frameBorder=no elementtype="2" HEIGHTOLD="770" WIDTHOLD="560" autoExecute="True" requests_list="0" name="report1"></IFRAME>
<INPUT style="POSITION: absolute; TOP: -100px; LEFT: -100px" id=layoutinfo type=hidden>
<INPUT style="POSITION: absolute; TOP: -100px; LEFT: -100px" id=ibiapp_app value=webpag type=hidden name="ibiapp_app">
<INPUT style="POSITION: absolute; TOP: -100px; LEFT: -100px" id=ibic_server value=EDASERVE type=hidden isdataserversarea="1" name="ibic_server">
<xml id=focus_xmlelement>
<script type="text/xml">
<rootxmlnode focoption="_FOC_NULL">
<variables>
<variable controltype="7" parametercreatedinreslay="0" type="default" desc="COUNTRY" name="COUNTRY" default=" " textvarname="" accept="0" select="0" create="0">
<link linktype="default">
<condition default="1" name="Default" whattodowithcontrol="4" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0">
<data_info checkForDuplicateValues="0" displayfield="COUNTRY" ibiformat="A10" datafield="COUNTRY" datasource="car.mas" datatype="0" selectedvalue=" " operation="" slider_range_from="" slider_range_to="">
<static_values>
<static value=" " display=" " selected="1" noinput="0"></static></static_values></data_info></condition></link>
<requestid id="0"></requestid></variable>
<variable controltype="7" parametercreatedinreslay="0" type="default" desc="NAM" name="NAM" default=" " textvarname="" accept="0" select="0" create="0">
<link linktype="default">
<condition default="1" name="Default" whattodowithcontrol="4" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0">
<data_info checkForDuplicateValues="0" displayfield="NAM" datafield="NAM" datasource="car.mas" datatype="0" selectedvalue=" " operation="" slider_range_from="" slider_range_to="">
<static_values>
<static value=" " display=" " selected="1" noinput="0"></static></static_values></data_info></condition></link>
<requestid id="0"></requestid></variable></variables>
<input_controls></input_controls>
<other_bound_objects></other_bound_objects>
<requests nextrequestsid="0">
<request requestid="0" targetname="report1" ibif_ex="report1" targettype="iframe" sourcetype="typeAdhocfex" activereport="0">
<![CDATA[-* File fex2.fex
-SET &ECHO=ALL;
-SET &COUNTRY = '!IBI.AMP.COUNTRY;';
-SET &NAM = '!IBI.AMP.NAM;';
TABLE FILE CAR
PRINT
'CAR.ORIGIN.COUNTRY'
'CAR.COMP.CAR'
'CAR.CARREC.MODEL'
WHERE CAR.ORIGIN.COUNTRY = '&COUNTRY'
HEADING
"Name : &NAM"
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = endeflt,
$
ENDSTYLE
END]]></request></requests></rootxmlnode></script>
</xml></BODY>
<SCRIPT id=IBI_loader type=text/javascript>
doBeforeLoad();
</SCRIPT>
</HTML>
Call web1.fex with a URL similar to
http://localhost:8080/ibi_apps/WFServlet?IBIF_ex=web1&NAM=JERRY
The parameter values are passed to the report piece of the HTML page via the !IBI.AMP.PARM1; syntax. Some may say this is not the best way to do it, but it's the quickest. The NAM variable defined in the HTML pages is not required, but I left them in.
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
March 30, 2012, 05:24 AM
MrMquote:
Francis
Thank you very much for your quick response. I have test this solution and it works fine for me.
So thanks again.
Mark
March 30, 2012, 10:48 AM
Francis MarianiI'm happy this works for you.
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
April 01, 2012, 05:43 AM
MrMFrancis,
Do you know what the guidelines are when I want to use 'Reference existing procedure'.
- read the querystring with javascipt (probaly onLoad webpage)
- filter all parameters
- but then ?
Source fexc.fex is the same as the application used in web1 (fex1.fex) send previously:
<HTML>
<HEAD>
<META id=mycharsetmeta content="text/html; charset=ISO-8859-1" http-equiv=Content-Type>
<META id=Generation content="Created in release 7701, Generation 3.0">
<SCRIPT id=IBI_RelCallBack type=text/javascript>function AdjustChildrenPosition(){
}
</SCRIPT>
<SCRIPT id=IBI_OptionsScript type=text/javascript>
var cgipath = "cgipath";
var ibirls = "ibirls3";
var rltdyncalendar = "rltdyncalendar";
var gmap = "ibigmap";
var olap="olap";
var olappanebase="olappanebase";
var olapdrill="olapdrill";
var ibixmltree="ibixmltree";
var ibiOptions = new Array(cgipath,ibirls);
</SCRIPT>
<SCRIPT id=IBI_nls type=text/javascript src="/ibi_html/javaassist/nls.js"></SCRIPT>
<SCRIPT id=IBI_nlsVars type=text/javascript src="/ibi_html/javaassist/nlsvars.js"></SCRIPT>
<SCRIPT id=IBI_ibigbl type=text/javascript src="/ibi_html/javaassist/ibi/html/js/ibigbl.js"></SCRIPT>
<SCRIPT id=IBI_ibigblloadCss type=text/javascript>
ibigblloadCss(null);
addIntlTranslatedJS("composertrans.js");
</SCRIPT>
<TITLE>HtmlPage</TITLE>
<SCRIPT id=clientEventHandlersJS type=text/javascript>
//Begin function window_onload
function window_onload() {
UpdateData();
// TODO: Add your event handler code here
//add onInitialUpdate() function to make changes before initial run of the reports
}
//End function window_onload
</SCRIPT>
<SCRIPT for=window type=text/javascript eventname="onload">window.onload = function() { window_onload(); }</SCRIPT>
<STYLE id=ibi_defaultstyleElt type=text/css>.tabitemsclass {
BACKGROUND-COLOR: white
}
</STYLE>
</HEAD>
<BODY style="OVERFLOW: auto" elementtype="21" thumbnailscale="4" edaconnectionrequired="true">
<SPAN style="Z-INDEX: 2; POSITION: absolute; WIDTH: 1180px; HEIGHT: 650px; TOP: 20px; LEFT: 30px" id=tab1 tabIndex=2 elementtype="38" tabitemsdefaultdist="5" tablocation="top" tabitemsdefaultwidth="100" tabitemsdefaultheight="25" tabedgerounded="straight">
<SPAN style="Z-INDEX: 5; BORDER-BOTTOM: white thin; POSITION: absolute; TEXT-ALIGN: center; BORDER-LEFT: teal 1px solid; WRITING-MODE: lr-tb; WIDTH: 100px; HEIGHT: 26px; BORDER-TOP: gold 3px solid; CURSOR: pointer; BORDER-RIGHT: teal 1px solid; TOP: 0px; LEFT: 15px" id=tabitem1 class=tabitemsclass tabIndex=3 elementtype="39" tabbody="tabitembody1" selectedtab="true">Tab #1</SPAN>
<SPAN style="Z-INDEX: 4; BORDER-BOTTOM: teal 1px solid; POSITION: absolute; BORDER-LEFT: teal 1px solid; WIDTH: 1180px; DISPLAY: block; HEIGHT: 700px; BORDER-TOP: teal 1px solid; BORDER-RIGHT: teal 1px solid; TOP: 25px; LEFT: 0px" id=tabitembody1 class=tabitemsclass tabIndex=4 elementtype="40">
<IFRAME style="Z-INDEX: 6; POSITION: absolute; WIDTH: 530px; HEIGHT: 680px; OVERFLOW: auto; TOP: 15px; LEFT: 20px" id=report1 title=fexc.fex tabIndex=7 src="" frameBorder=no elementtype="2" autoExecute="true" requests_list="0" WIDTHOLD="530" HEIGHTOLD="680" name="report1"></IFRAME></SPAN>
<SPAN style="Z-INDEX: 3; BORDER-BOTTOM: white thin; POSITION: absolute; TEXT-ALIGN: center; BORDER-LEFT: teal 1px solid; WRITING-MODE: lr-tb; WIDTH: 100px; HEIGHT: 22px; BORDER-TOP: teal 1px solid; CURSOR: pointer; BORDER-RIGHT: teal 1px solid; TOP: 3px; LEFT: 120px" id=tabitem2 class=tabitemsclass tabIndex=5 elementtype="39" tabbody="tabitembody2" selectedtab="false">Tab #2</SPAN>
<SPAN style="Z-INDEX: 2; BORDER-BOTTOM: teal 1px solid; POSITION: absolute; BORDER-LEFT: teal 1px solid; WIDTH: 1180px; DISPLAY: none; HEIGHT: 625px; BORDER-TOP: teal 1px solid; BORDER-RIGHT: teal 1px solid; TOP: 25px; LEFT: 0px" id=tabitembody2 class=tabitemsclass tabIndex=6 elementtype="40"></SPAN></SPAN>
<INPUT style="POSITION: absolute; TOP: -100px; LEFT: -100px" id=layoutinfo type=hidden tabcontrolids="tab1">
<INPUT style="POSITION: absolute; TOP: -100px; LEFT: -100px" id=ibiapp_app value=webpag type=hidden name="ibiapp_app">
<INPUT style="POSITION: absolute; TOP: -100px; LEFT: -100px" id=ibic_server value=EDASERVE type=hidden isdataserversarea="1" name="ibic_server">
<xml id=focus_xmlelement>
<script type="text/xml" nextelementuniquenumber="2">
<rootxmlnode focoption="_FOC_NULL" top="10" left="10" width="150" height="130">
<variables>
<variable controltype="7" parametercreatedinreslay="0" type="default" desc="NAM" name="NAM" default=" " textvarname="" accept="0" select="0" create="0" top="21" left="1" width="60" height="20" inbinding="0">
<link linktype="default" persistentuniqueid="compUid_1">
<condition default="1" name="Default" whattodowithcontrol="4" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0">
<data_info checkForDuplicateValues="0" displayfield="NAM" datafield="NAM" datasource="car.mas" datatype="0" selectedvalue=" " operation="" slider_range_from="" slider_range_to="" linktype="none" sourcetype="typeMaster">
<static_values>
<static value=" " display=" " selected="1" noinput="0"></static></static_values></data_info></condition></link>
<requestid id="0"></requestid></variable></variables>
<input_controls></input_controls>
<other_bound_objects></other_bound_objects>
<requests nextrequestsid="0">
<request requestid="0" targettype="iframe" targetname="report1" sourcetype="typeFex" ibif_ex="fexc.fex" ibiapp_app="webpag" activereport="0"></request></requests></rootxmlnode></script>
</xml></BODY>
<SCRIPT id=IBI_loader type=text/javascript>
doBeforeLoad();
</SCRIPT>
</HTML>