Thank you franics..
I had an include file as report which has the above varaible of the folder name etc, needs to put that into an HTML file which is our lanuch page for reports.. so that we can avaoid actual hard coing..
The last 2 contents is where i refernce the variables currenly hard code..
<request requestid="1" sourcetype="typeFex" targettype="window" targetname="_blank" ibif_ex="app/nostro_reconciliation.fex" IBIMR_domain="wssqah9c/wssqah9c.htm" IBIMR_folder="#treasuryoper" IBIMR_dir="#wssreportsfr" IBIMR_sub_action="MR_STD_REPORT" activereport="0" reportcolumns="" ibiapp_app="wss_qa"></request>
<request requestid="2" sourcetype="typeFex" targettype="defer" targetname="_blank" ibif_ex="app/nostro_reconciliation.fex" IBIMR_domain="wssqah9c/wssqah9c.htm" IBIMR_folder="#treasuryoper" IBIMR_dir="#wssreportsfr" IBIMR_sub_action="MR_STD_REPORT" activereport="0" reportcolumns="" ibiapp_app="wss_qa"></request>
My full HTML report is..
<!-- Generated by Report Layout Painter -->
<HTML>
<HEAD>
<META id=mycharsetmeta http-equiv=Content-Type content="text/html; charset=ISO-8859-1">
<META id=Generation content="Gen 3.0">
<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,rltdyncalendar);
</SCRIPT>
<TITLE>HtmlPage</TITLE>
<SCRIPT id=IBI_RelCallBack type=text/javascript>function AdjustChildrenPosition(){
}
</SCRIPT>
<SCRIPT id=IBI_nls src="/ibi_html/javaassist/nls.js" type=text/javascript></SCRIPT>
<SCRIPT id=IBI_nlsVars src="/ibi_html/javaassist/nlsvars.js" type=text/javascript></SCRIPT>
<SCRIPT id=IBI_ibigbl src="/ibi_html/javaassist/ibi/html/js/ibigbl.js" type=text/javascript></SCRIPT>
<SCRIPT id=IBI_ibigblloadCss type=text/javascript>
ibigblloadCss(null);
</SCRIPT>
<SCRIPT id=dateVal src="/approot/baseapp/date_validation.js" type=text/javascript></SCRIPT>
<SCRIPT id=dateVal2 src="/approot/wss/wss_date_validation.js" type=text/javascript></SCRIPT>
<SCRIPT id=clientEventHandlersJS type=text/javascript>
//Begin function window_onload
function window_onload() {
UpdateData();
// To add Current date in the FROM and TO date fields
//To add default value for FROM_DATE to be beginning of month and TO_DATE to be today date
//JC commenting as Business doesnt want this // document.getElementById("FROM_DATE").value=getBeginningOfMonthDate();
//JC commenting as Business doesnt want this ////document.getElementById("TO_DATE").value=getTodayDate();
//Setting the value to be null as there is a bug with calendar.
document.getElementById("FROM_DATE").value="";
//Setting the value to be null as there is a bug with calendar.
//document.getElementById("TO_DATE").value="";
document.getElementById("FROM_DATE").focus();
document.form2.ITEM1.disabled = true;
// TODO: Add your event handler code here
//add onInitialUpdate() function to make changes before initial run of the reports
}
//End function window_onload
//Begin function FROM_DATE_onblur
function FROM_DATE_onblur(ctrl) {
document.form2.ITEM1.disabled = true;
if(ValidateDate(ctrl) == true) {
return true;
}
return false;
}
//End function FROM_DATE_onblur
//Begin function DATE_onclick
function DATE_onclick(ctrl) {
document.form2.ITEM1.disabled = true;
if(ValidateDate(ctrl) == true) {
return true;
}
return false;
}
//End function DATE_onclick
//Begin function TO_DATE_onblur
function TO_DATE_onblur(ctrl) {
document.form2.ITEM1.disabled = true;
if ((ValidateDate(ctrl)) == true) {
var FromDate = document.getElementById("FROM_DATE");
return true;
}
return false;
}
//End function TO_DATE_onblur
//Begin function DATE_FORMAT_onblur
function DATE_FORMAT_onblur(ctrl) {
document.form2.ITEM1.disabled = true;
var FromDate = document.getElementById("FROM_DATE");
if (((ValidateDate(FromDate)) == true)) {
document.form2.ITEM1.disabled = false;
return true;
}
return false;
}
//End function DATE_FORMAT_onblur
//Begin function form_reset
function form_reset() {
document.form2.ITEM1.disabled = true;
return true;
}
//End function form_reset
</SCRIPT>
</HEAD>
<BODY style="OVERFLOW: auto" edaconnectionrequired="true" nextelementuniquenumber="19">
<SCRIPT for=window eventname="onload">window.onload = function() { window_onload(); }</SCRIPT>
<FORM id=form2 style="Z-INDEX: 2; LEFT: 10px; WIDTH: 830px; POSITION: absolute; TOP: 10px; HEIGHT: 430px" name=form2 onsubmit="OnExecute(this);return false;" method=post requests_list="1" form_dist_between_desc_and_input="10" form_hor_dist_between_controls="10" vert_dist_between_controls="10" form_number_of_columns="4" form_number_of_visible_rows="4" form_prompt_location="1" default_slider_type="4" fexlist_list="report1">
<INPUT language=javascript id=form2Submit style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; Z-INDEX: 3; LEFT: 130px; WIDTH: 38px; COLOR: black; BACKGROUND-REPEAT: no-repeat; FONT-FAMILY: Arial; POSITION: absolute; TOP: 330px; HEIGHT: 22px; BACKGROUND-COLOR: lavender; FONT-VARIANT: normal" onclick=DATE_FORMAT_onblur(this) tabIndex=4 type=submit value=Run name=ITEM1>
<INPUT id=form2Reset style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; Z-INDEX: 4; LEFT: 200px; WIDTH: 60px; BACKGROUND-REPEAT: no-repeat; FONT-FAMILY: Arial; POSITION: absolute; TOP: 330px; HEIGHT: 22px; BACKGROUND-COLOR: lavender" onclick=form_reset(this) tabIndex=5 type=reset size=31 value=Refresh name=reset1>
<FIELDSET id=form2_formbodyid style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; Z-INDEX: 5; LEFT: 10px; PADDING-BOTTOM: 0px; OVERFLOW: auto; WIDTH: 480px; BORDER-TOP-STYLE: none; PADDING-TOP: 0px; BORDER-RIGHT-STYLE: none; BORDER-LEFT-STYLE: none; POSITION: absolute; TOP: 140px; HEIGHT: 170px; BORDER-BOTTOM-STYLE: none" formbody="1" tempwidth="500" tempheight="134">
<SPAN id=pane2 style="Z-INDEX: 8; LEFT: 105px; WIDTH: 150px; POSITION: absolute; TOP: 0px; HEIGHT: 150px; BACKGROUND-COLOR: silver" tabIndex=0 name="calendar1" elementtype="32">
<INPUT language=javascript class=FROM_DATE id=FROM_DATE onblur=FROM_DATE_onblur(this) style="Z-INDEX: 9; LEFT: 0px; WIDTH: 100px; POSITION: absolute; TOP: 109px; HEIGHT: 22px" onclick=DATE_onclick(this) tabIndex=1 hspace=0 maxLength=10 onchange=FROM_DATE_onblur(this) size=10 value=" " name=calendar1 elementtype="14" operation="NONE" persistentuniqueid="compUid_7" boundtovariable="1" defaultlocation="29,0,51,100">Please select "Value Date" for report.
<BR>
<BR>YYYY/MM/DD
<BR>
<BR>
<BR>
<BR></SPAN>
<SPAN id=pane5 style="Z-INDEX: 14; LEFT: 280px; WIDTH: 130px; POSITION: absolute; TOP: 0px; HEIGHT: 150px; BACKGROUND-COLOR: silver" tabIndex=0 name="combobox3" elementtype="32" persistentuniqueid="compUid_1">Please select the date format for report
<SELECT class=DATE_FORMAT id=DATE_FORMAT style="Z-INDEX: 15; LEFT: 0px; WIDTH: 120px; POSITION: absolute; TOP: 109px" onclick=DATE_FORMAT_onblur(this) tabIndex=3 size=1 name=combobox3 persistentuniqueid="compUid_10" boundtovariable="1" defaultlocation="29,0,51,77">
<OPTION value=YYMD selected displaytext="YYYY/MM/DD">YYYY/MM/DD</OPTION>
<OPTION value=MDYY displaytext="MM/DD/YYYY">MM/DD/YYYY</OPTION>
<OPTION value=DMYY displaytext="DD/MM/YYYY">DD/MM/YYYY</OPTION></SELECT></SPAN></FIELDSET>
<INPUT id=form2Defer style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; Z-INDEX: 16; LEFT: 290px; WIDTH: 90px; COLOR: black; BACKGROUND-REPEAT: no-repeat; FONT-FAMILY: Arial; POSITION: absolute; TOP: 330px; HEIGHT: 22px; BACKGROUND-COLOR: lavender" onclick="OnExecute(this);return false;" tabIndex=6 type=button size=45 value="Deferred Run" name=button1 requests_list="2">
<SPAN id=text1 style="Z-INDEX: 18; LEFT: 100px; WIDTH: 340px; POSITION: absolute; TOP: 70px; HEIGHT: 40px; BACKGROUND-COLOR: #ccccff" tabIndex=0>
<FONT style="FONT-WEIGHT: bold; FONT-SIZE: 24pt; FONT-FAMILY: Arial">Nostro Reconciliation</FONT></SPAN></FORM>
<INPUT id=IBIMR_dir style="LEFT: -100px; POSITION: absolute; TOP: -100px" type=hidden value=#wssreportsfr name=IBIMR_dir persistentuniqueid="compUid_11" name="IBIMR_dir">
<INPUT id=layoutinfo style="LEFT: -100px; POSITION: absolute; TOP: -100px" type=hidden persistentuniqueid="compUid_14">
<INPUT id=IBIMR_domain style="LEFT: -100px; POSITION: absolute; TOP: -100px" type=hidden value=wssuvpkm/wssuvpkm.htm name=IBIMR_domain persistentuniqueid="compUid_15" name="IBIMR_domain">
<INPUT id=IBIMR_folder style="LEFT: -100px; POSITION: absolute; TOP: -100px" type=hidden value=#treasuryoper name=IBIMR_folder persistentuniqueid="compUid_16" name="IBIMR_folder">
<INPUT id=ibif_ex style="LEFT: -100px; POSITION: absolute; TOP: -100px" type=hidden value=app/nostro_reconciliation.htm name=ibif_ex persistentuniqueid="compUid_17" name="ibif_ex">
<INPUT id=ibiapp_app style="LEFT: -100px; POSITION: absolute; TOP: -100px" type=hidden value=wss name=ibiapp_app persistentuniqueid="compUid_18" ismre="1" name="ibiapp_app">
<INPUT id=ibic_server style="LEFT: -100px; POSITION: absolute; TOP: -100px" type=hidden value=WFASERV name=ibic_server persistentuniqueid="compUid_19" name="ibic_server">
<xml id=focus_xmlelement>
<script>
<rootxmlnode top="20" left="509" width="150" height="130">
<variables>
<variable controltype="8" parametercreatedinreslay="0" type="default" desc="WSS_GDP_SITE" name="WSS_GDP_SITE" default="PRO" textvarname="" accept="0" select="0" create="1" top="287" left="32" width="60" height="20" inbinding="1">
<link linktype="default">
<condition default="1" name="Default" whattodowithcontrol="4" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0">
<data_info displayfield="WSS_GDP_SITE" datafield="WSS_GDP_SITE" datasource="ord_bt.mas" datatype="0" selectedvalue="PRO" operation="" slider_range_from="" slider_range_to="" linktype="none"></data_info></condition></link>
<requestid id="1"></requestid>
<requestid id="2"></requestid>
</variable>
<variable controltype="14" parametercreatedinreslay="0" type="default" desc="FROM_DATE" name="FROM_DATE" default="getTodayDate()" textvarname="" accept="0" select="0" create="1" top="289" left="158" width="60" height="20" inbinding="1">
<link linktype="default" from="compUid_7">
<condition default="1" name="Default" whattodowithcontrol="4" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0">
<data_info displayfield="FROM_DATE" datafield="FROM_DATE" datasource="ord_bt.mas" datatype="0" selectedvalue="" operation="" slider_range_from="" slider_range_to="" linktype="none"></data_info></condition></link>
<requestid id="1"></requestid>
<requestid id="2"></requestid>
</variable>
<variable controltype="14" parametercreatedinreslay="0" type="default" desc="TO_DATE" name="TO_DATE" default="" textvarname="" accept="0" select="0" create="1" top="289" left="268" width="60" height="20" inbinding="1">
<link linktype="default">
<condition default="1" name="Default" whattodowithcontrol="4" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0">
<data_info displayfield="TO_DATE" datafield="TO_DATE" datasource="ord_bt.mas" datatype="0" selectedvalue="" operation="" slider_range_from="" slider_range_to="" linktype="none"></data_info></condition></link>
<requestid id="1"></requestid>
<requestid id="2"></requestid>
</variable>
<variable controltype="8" parametercreatedinreslay="0" type="default" desc="OUTPUT_FORMAT" name="OUTPUT_FORMAT" default="HTML" textvarname="" accept="0" select="0" create="1" top="289" left="378" width="60" height="20" inbinding="1">
<link linktype="default">
<condition default="1" name="Default" whattodowithcontrol="4" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0">
<data_info displayfield="OUTPUT_FORMAT" datafield="OUTPUT_FORMAT" datasource="ord_bt.mas" datatype="0" selectedvalue="HTML" operation="" slider_range_from="" slider_range_to=""></data_info></condition></link>
<requestid id="1"></requestid>
<requestid id="2"></requestid>
</variable>
<variable controltype="8" parametercreatedinreslay="0" type="default" desc="DATE_FORMAT" name="DATE_FORMAT" default="YYMD" textvarname="" accept="0" select="0" create="1" top="283" left="484" width="60" height="20" inbinding="1">
<link linktype="default" from="compUid_10">
<condition default="1" name="Default" whattodowithcontrol="4" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0">
<data_info displayfield="DATE_FORMAT" datafield="DATE_FORMAT" datasource="ord_bt.mas" datatype="0" selectedvalue="YYMD" operation="" slider_range_from="" slider_range_to="" linktype="none"></data_info></condition></link>
<requestid id="1"></requestid>
<requestid id="2"></requestid>
</variable>
<variable controltype="7" parametercreatedinreslay="0" type="unresolved" desc="ValueDateFormatted" name="ValueDateFormatted" default="" textvarname="" accept="0" select="0" create="0" top="21" left="1" width="60" height="20" inbinding="0">
<link linktype="default">
<condition default="1" name="Default" whattodowithcontrol="4" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0">
<data_info displayfield="ValueDateFormatted" datafield="ValueDateFormatted" datasource="ord_bt.mas" datatype="0" selectedvalue="" operation="" slider_range_from="" slider_range_to=""></data_info></condition></link>
<requestid id="2"></requestid>
<requestid id="1"></requestid></variable></variables>
<input_controls>
<input_control bindcontrolid="compUid_7" inbinding="1" top="219" left="158" width="60" height="20" elementtype="14" requiredfield="0" name="calendar1" id="FROM_DATE" multiple="0" unresolved="0" onetimepopulated="1">
<link linktype="default">
<condition default="1" name="Default" whattodowithcontrol="0" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0">
<data_info datatype="0" datasource="ord_bt.mas" addalloption="0" sourcetype="typeMaster" cacheruntimedata="0" calendardata="0/0/-50;0/0/0" calendardatatype="1" ibiformat="YYMD" accept="0" selectedvalue=" " operation="NONE">
<static_values>
<static value=" " display=" " selected="1"></static></static_values></data_info></condition></link></input_control>
<input_control bindcontrolid="compUid_10" inbinding="1" top="207" left="476" width="60" height="20" elementtype="8" requiredfield="0" name="combobox3" id="DATE_FORMAT" multiple="0" unresolved="0" onetimepopulated="1">
<link linktype="default">
<condition default="1" name="Default" whattodowithcontrol="0" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0">
<data_info datatype="0" datasource="ord_bt.mas" addalloption="0" sourcetype="typeMaster" cacheruntimedata="0" accept="0" selectedvalue="YYMD" operation="NONE">
<static_values>
<static value="YYMD" display="YYYY/MM/DD" selected="1"></static>
<static value="MDYY" display="MM/DD/YYYY" selected="0"></static>
<static value="DMYY" display="DD/MM/YYYY" selected="0"></static></static_values></data_info></condition></link></input_control>
<input_control bindcontrolid="compUid_11" name="IBIMR_dir" id="IBIMR_dir" multiple="0" inbinding="1" top="15" left="5" width="60" height="20" onetimepopulated="1">
<link linktype="default">
<condition default="1" name="Default" whattodowithcontrol="0" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0">
<data_info></data_info></condition></link></input_control>
<input_control bindcontrolid="compUid_14" inbinding="1" top="0" left="0" width="60" height="20" elementtype="26" name="layoutinfo" id="layoutinfo" multiple="0" onetimepopulated="1">
<link linktype="default">
<condition default="1" name="Default" whattodowithcontrol="0" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0">
<data_info accept="0">
<static_values>
<static value="" display="" selected="0"></static></static_values></data_info></condition></link></input_control>
<input_control bindcontrolid="compUid_15" inbinding="1" top="0" left="0" width="60" height="20" elementtype="26" name="IBIMR_domain" id="IBIMR_domain" multiple="0" onetimepopulated="1">
<link linktype="default">
<condition default="1" name="Default" whattodowithcontrol="0" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0">
<data_info accept="0">
<static_values>
<static value="wssuvpkm/wssuvpkm.htm" display="" selected="0"></static></static_values></data_info></condition></link></input_control>
<input_control bindcontrolid="compUid_16" inbinding="1" top="0" left="0" width="60" height="20" elementtype="26" name="IBIMR_folder" id="IBIMR_folder" multiple="0" onetimepopulated="1">
<link linktype="default">
<condition default="1" name="Default" whattodowithcontrol="0" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0">
<data_info accept="0">
<static_values>
<static value="#treasuryoper" display="" selected="0"></static></static_values></data_info></condition></link></input_control>
<input_control bindcontrolid="compUid_17" inbinding="1" top="0" left="0" width="60" height="20" elementtype="26" name="ibif_ex" id="ibif_ex" multiple="0" onetimepopulated="1">
<link linktype="default">
<condition default="1" name="Default" whattodowithcontrol="0" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0">
<data_info accept="0">
<static_values>
<static value="app/nostro_reconciliation.htm" display="" selected="0"></static></static_values></data_info></condition></link></input_control>
<input_control bindcontrolid="compUid_18" inbinding="1" top="0" left="0" width="60" height="20" elementtype="26" name="ibiapp_app" id="ibiapp_app" multiple="0" onetimepopulated="1">
<link linktype="default">
<condition default="1" name="Default" whattodowithcontrol="0" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0">
<data_info accept="0">
<static_values>
<static value="wss" display="" selected="0"></static></static_values></data_info></condition></link></input_control>
<input_control bindcontrolid="compUid_19" inbinding="1" top="0" left="0" width="60" height="20" elementtype="26" name="ibic_server" id="ibic_server" multiple="0" onetimepopulated="1">
<link linktype="default">
<condition default="1" name="Default" whattodowithcontrol="0" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0">
<data_info accept="0">
<static_values>
<static value="WFASERV" display="" selected="0"></static></static_values></data_info></condition></link></input_control></input_controls>
<other_bound_objects></other_bound_objects>
<requests nextrequestsid="3">
<request requestid="1" sourcetype="typeFex" targettype="window" targetname="_blank" ibif_ex="app/nostro_reconciliation.fex" IBIMR_domain="wssqah9c/wssqah9c.htm" IBIMR_folder="#treasuryoper" IBIMR_dir="#wssreportsfr" IBIMR_sub_action="MR_STD_REPORT" activereport="0" reportcolumns="" ibiapp_app="wss_qa"></request>
<request requestid="2" sourcetype="typeFex" targettype="defer" targetname="_blank" ibif_ex="app/nostro_reconciliation.fex" IBIMR_domain="wssqah9c/wssqah9c.htm" IBIMR_folder="#treasuryoper" IBIMR_dir="#wssreportsfr" IBIMR_sub_action="MR_STD_REPORT" activereport="0" reportcolumns="" ibiapp_app="wss_qa"></request>
</requests></rootxmlnode>
</script>
</xml></BODY>
<SCRIPT id=IBI_loadcalendar type=text/javascript>
if(ibigblInitInfo.testOptions(rltdyncalendar)){
setDateRange();
setupDocCalendars();
}</SCRIPT>
<SCRIPT id=IBI_loader type=text/javascript>
//doBeforeLoad();
</SCRIPT>
</HTML>
WebFOCUS 76
Windows
all formats