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.
Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.
From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
Request access to the private WebFOCUS User Group (login required) to network with fellow members.
Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.
Read-Only TopicGo
Search
Notify
Admin
New PM!
Platinum Member posted August 18, 2014 01:41 PM
Hello from Waco…
How do I display drop downs and or text on an HTML screen based on selection made to radio button.
Example
Screen loads and their first question is...
More than 1 owner Occupied Residence
Radio1) Yes. If they select Yes they will see.
Additional Owner Occupied Residence (Drop down) 1-10.
If they don't select Yes they don’t get the drop down and they will go to next questions.
Next question…
Rental units? (Radio2) Yes. If they select Yes they will see the following drop downs.
Single Family 1 -20
Duplex 1-10
Triplex 1- 6
Quadruplex 1-5
If they don’t select Yes they will not see the drop downs and they will move on to next questions.
Selections are saved off for later use on quote.
Clear as mud?
I think this is a onclick function but I am not sure.
Thanks
JV
This message has been edited. Last edited by: <Kathryn Henning>, August 25, 2014 02:00 PM WebFOCUS 8105m Windows, All Outputs
Master You need to write a Javascript function to handle this. Yes you need to use onclick even on the radio buttons and change the visibility property of list box to visible or hidden based on the selection.
Thanks,
Ram
Posts: 542 | Location: Dearborn, MI | Registered: June 03, 2009
IP
Platinum Member Ok, thanks Ram. I will see what I can come up with, I am a bit rusty when it comes to JS.
WebFOCUS 8105m Windows, All Outputs
Platinum Member Where do you put the JS code in the HTML?
WebFOCUS 8105m Windows, All Outputs
Expert Hi Jveselka,
Here is an example; "may" have to change some names, i.e., ibiapp_app.
This is from 7.7.03...
<!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 7703, 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>Fordham University - Trial Balance Process (BannerTables)</TITLE>
<SCRIPT id=clientEventHandlersJS type=text/javascript>
function window_onload()
{
UpdateData();
document.getElementById("edit2").style.display='block';
document.getElementById("label9").style.display='block'; //show Fiscal Year
document.getElementById("label10").style.display='block'; //show Fiscal Period
document.getElementById("checkbox1").style.display='block';
document.getElementById("item10").style.display='none';
document.getElementById("pane6").style.display='none';
document.getElementById("edit4").style.display='none';
document.getElementById("item20").style.display='none';
document.getElementById("pane7").style.display='none';
document.getElementById("edit5").style.display='none';
}
</SCRIPT>
<SCRIPT language=JavaScript>
var isNN = (navigator.appName.indexOf("Netscape")!=-1);
function autoTab(input,len, e) {
var keyCode = (isNN) ? e.which : e.keyCode;
var filter = (isNN) ? [0,8,9] : [0,8,9,16,17,18,37,38,39,40,46];
if(input.value.length >= len && !containsElement(filter,keyCode)) {
input.value = input.value.slice(0, len);
input.form[(getIndex(input)+1) % input.form.length].focus();
}
function containsElement(arr, ele) {
var found = false, index = 0;
while(!found && index < arr.length)
if(arr[index] == ele)
found = true;
else
index++;
return found;
}
function getIndex(input) {
var index = -1, i = 0, found = false;
while (i < input.form.length && index == -1)
if (input.form[i] == input)index = i;
else i++;
return index;
}
return true;
}
</SCRIPT>
<SCRIPT type=text/javascript>
function doClick(obj_Radio2)
{
if (obj_Radio2.value=="0"){
document.getElementById("edit2").style.display='block';
document.getElementById("label9").style.display='block'; //show Fiscal Year
document.getElementById("label10").style.display='block'; //show Fiscal Period
document.getElementById("checkbox1").style.display='block';
document.getElementById("item10").style.display='none';
document.getElementById("pane6").style.display='none';
document.getElementById("edit4").style.display='none';
document.getElementById("item20").style.display='none';
document.getElementById("pane7").style.display='none';
document.getElementById("edit5").style.display='none';
}
else
if (obj_Radio2.value=="1"){
document.getElementById("edit2").style.display='block';
document.getElementById("label9").style.display='block'; //show Fiscal Year
document.getElementById("label10").style.display='none'; //hide Fiscal Period
document.getElementById("item10").style.display='none';
document.getElementById("pane6").style.display='none';
document.getElementById("edit4").style.display='none';
document.getElementById("item20").style.display='none';
document.getElementById("pane7").style.display='none';
document.getElementById("edit5").style.display='none';
document.getElementById("checkbox1").style.display='none';
}
else
if (obj_Radio2.value=="2"){
document.getElementById("edit2").style.display='block';
document.getElementById("label9").style.display='block'; //show Fiscal Year
document.getElementById("label10").style.display='block'; //show Fiscal Period
document.getElementById("item10").style.display='block';
document.getElementById("pane6").style.display='block';
document.getElementById("edit4").style.display='block';
document.getElementById("item20").style.display='block';
document.getElementById("pane7").style.display='block';
document.getElementById("edit5").style.display='block';
document.getElementById("checkbox1").style.display='none';
}
else
if (obj_Radio2.value=="3"){
document.getElementById("item10").style.display='none';
document.getElementById("pane6").style.display='none';
document.getElementById("edit4").style.display='none';
document.getElementById("item20").style.display='none';
document.getElementById("pane7").style.display='none';
document.getElementById("edit5").style.display='none';
document.getElementById("label10").style.display='none'; //hide Fiscal Period
document.getElementById("checkbox1").style.display='none';
document.getElementById("edit2").style.display='none';
document.getElementById("label9").style.display='none'; //hide Fiscal Year
}
}
</SCRIPT>
<SCRIPT type=text/javascript>
function iframe_msg1() {
document.all.iframe1.src = 'General Ledger Extract Running';
}
</SCRIPT>
<SCRIPT for=window type=text/javascript eventname="onload">window.onload = function() { window_onload(); }
function showRunning() {
window["iframe1"].document.body.innerHTML = "<b>Running, please wait...</b>";
}
</SCRIPT>
</HEAD>
<BODY style="OVERFLOW: auto" thumbnailscale="4" persistentuniqueid="compUid_35" elementtype="21" edaconnectionrequired="true" nextelementuniquenumber="43">
<INPUT tabIndex=39 id=edit1 style="BORDER-TOP-STYLE: none; BORDER-LEFT-STYLE: none; HEIGHT: 18px; BORDER-BOTTOM-STYLE: none; POSITION: absolute; FONT-WEIGHT: bold; COLOR: white; BORDER-RIGHT-STYLE: none; LEFT: 440px; Z-INDEX: 42; TOP: 50px; WIDTH: 360px; BACKGROUND-COLOR: transparent" value="Finance Balance Reports (Banner Tables)" persistentuniqueid="compUid_1" name="edit1">
<SPAN tabIndex=31 id=line1 style="BORDER-TOP-STYLE: none; FONT-SIZE: 1pt; BORDER-LEFT-STYLE: none; HEIGHT: 90px; BORDER-COLLAPSE: collapse; TABLE-LAYOUT: auto; BORDER-BOTTOM-STYLE: none; POSITION: absolute; BORDER-RIGHT-STYLE: none; LEFT: 0px; Z-INDEX: -1; TOP: 0px; WIDTH: 100%; BACKGROUND-COLOR: #900028" elementtype="5"></SPAN>
<IFRAME tabIndex=58 id=iframe1 style="HEIGHT: 190px; POSITION: absolute; LEFT: 3px; Z-INDEX: 61; TOP: 420px; WIDTH: 999px" src="" frameBorder=no scrolling=no persistentuniqueid="compUid_21" WIDTHOLD="999" HEIGHTOLD="810" autoExecute="False" name="iframe1"></IFRAME>
<FORM tabIndex=59 id=form2 onsubmit="OnExecute(this);return false;" style="HEIGHT: 310px; POSITION: absolute; LEFT: 0px; Z-INDEX: 62; TOP: 90px; WIDTH: 980px" method=post persistentuniqueid="compUid_38" 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" requests_list="14" fexlist_list="form2" form_type="2" name="form2">
<INPUT tabIndex=60 id=form2Submit style="HEIGHT: 22px; BACKGROUND-REPEAT: no-repeat; POSITION: absolute; LEFT: 380px; Z-INDEX: 63; TOP: 280px; WIDTH: 38px; BACKGROUND-COLOR: lavender" type=submit value=" " persistentuniqueid="compUid_31" StyleBack_rtFileName="htmlpathsub/javaassist/ibi/html/describe/run16.gif" name="ITEM1">
<INPUT tabIndex=61 id=form2Reset style="HEIGHT: 22px; BACKGROUND-REPEAT: no-repeat; POSITION: absolute; LEFT: 420px; Z-INDEX: 64; TOP: 280px; WIDTH: 38px; BACKGROUND-COLOR: lavender" type=reset value=" " StyleBack_rtFileName="htmlpathsub/javaassist/ibi/html/describe/reset.gif" name="reset1">
<FIELDSET tabIndex=62 id=form2_formbodyid style="BORDER-TOP-STYLE: none; OVERFLOW: auto; BORDER-LEFT-STYLE: none; HEIGHT: 270px; BORDER-BOTTOM-STYLE: none; POSITION: absolute; PADDING-BOTTOM: 0px; PADDING-TOP: 0px; BORDER-RIGHT-STYLE: none; PADDING-LEFT: 0px; LEFT: 0px; Z-INDEX: 65; TOP: 0px; PADDING-RIGHT: 0px; WIDTH: 970px" persistentuniqueid="compUid_30" formbody="1" tempwidth="544" tempheight="105">
<SPAN tabIndex=67 id=pane3 style="BORDER-TOP-STYLE: ridge; BORDER-LEFT-STYLE: ridge; HEIGHT: 220px; BORDER-BOTTOM-STYLE: ridge; POSITION: absolute; BORDER-RIGHT-STYLE: ridge; LEFT: 580px; Z-INDEX: 70; TOP: 10px; WIDTH: 280px" persistentuniqueid="compUid_40" elementtype="32" name="FMT">
<STRONG>Format</STRONG>
<SPAN tabIndex=74 id=radio1 contentEditable=false style="HEIGHT: 150px; POSITION: absolute; LEFT: 10px; Z-INDEX: 76; TOP: 25px; WIDTH: 240px" persistentuniqueid="compUid_4" elementtype="12" columns="1" boundtovariable="1" groupChildren="1" name="FMT">
<TABLE contentEditable=false style="HEIGHT: 100%; WIDTH: 100%" cellSpacing=0 cellPadding=0>
<TBODY>
<TR>
<TD>
<INPUT tabIndex=74 id=radio1_0 CHECKED type=radio value=EXL2K displaytext="EXCEL" name="FMT">
<LABEL id=radio1_LABEL_0 style="CURSOR: default" for=radio1_0>EXCEL</LABEL></TD></TR>
<TR>
<TD>
<INPUT tabIndex=74 id=radio1_1 type=radio value=PDF displaytext="PDF" name="FMT">
<LABEL id=radio1_LABEL_1 style="CURSOR: default" for=radio1_1>PDF</LABEL></TD></TR>
<TR>
<TD>
<INPUT tabIndex=74 id=radio1_2 type=radio value=EXL2K displaytext="CSV" name="radio1">
<LABEL id=radio1_LABEL_2 style="CURSOR: default" for=radio1_2>CSV (NA yet)</LABEL></TD></TR>
<TR>
<TD>
<INPUT tabIndex=74 id=radio1_3 type=radio value=HTML displaytext="Active Report(Balance Sheet only)" name="radio1">
<LABEL id=radio1_LABEL_3 style="CURSOR: default" for=radio1_3>HTML (Balance Sheet only)</LABEL></TD></TR>
<TR>
<TD>
<INPUT tabIndex=74 id=radio1_4 type=radio value=EXL2K displaytext="TAB Delimited" name="radio1">
<LABEL id=radio1_LABEL_4 style="CURSOR: default" for=radio1_4>TAB Delimited (NA yet)</LABEL></TD></TR></TBODY></TABLE></SPAN></SPAN>
<SPAN tabIndex=71 id=pane5 style="BORDER-TOP-STYLE: ridge; BORDER-LEFT-STYLE: ridge; HEIGHT: 160px; BORDER-BOTTOM-STYLE: ridge; POSITION: absolute; BORDER-RIGHT-STYLE: ridge; LEFT: 0px; Z-INDEX: 74; TOP: 10px; WIDTH: 276px" persistentuniqueid="compUid_22" elementtype="32" name="REPORT">
<STRONG> Select Report</STRONG>
<SPAN tabIndex=75 id=radio2 contentEditable=false style="HEIGHT: 110px; POSITION: absolute; LEFT: 0px; Z-INDEX: 77; TOP: 30px; WIDTH: 255px" persistentuniqueid="compUid_8" elementtype="12" columns="1" boundtovariable="1" groupChildren="1" name="REPORT">
<TABLE contentEditable=false style="HEIGHT: 100%; WIDTH: 100%" cellSpacing=0 cellPadding=0>
<TBODY>
<TR>
<TD>
<INPUT onclick=doClick(this) tabIndex=75 id=radio2_0 CHECKED type=radio value=0 persistentuniqueid="compUid_9" displaytext="Trial Balance - Summary/Detail" noinput="0" name="radio2">
<LABEL id=radio2_LABEL_0 style="CURSOR: default" for=radio2_0>Trial Balance - Summary/Detail</LABEL></TD></TR>
<TR>
<TD>
<INPUT onclick=doClick(this) tabIndex=75 id=radio2_1 type=radio value=1 persistentuniqueid="compUid_10" displaytext="Fiscal Year Beginning Balance" noinput="0" name="radio2">
<LABEL id=radio2_LABEL_1 style="CURSOR: default" for=radio2_1>Fiscal Year Beginning Balance</LABEL></TD></TR>
<TR>
<TD>
<INPUT onclick=doClick(this) tabIndex=75 id=radio2_2 type=radio value=2 displaytext="Balance Sheet Detail" noinput="0" name="radio2">
<LABEL id=radio2_LABEL_2 style="CURSOR: default" for=radio2_2>Balance Sheet Detail</LABEL></TD></TR></TBODY></TABLE></SPAN></SPAN>
<LABEL tabIndex=76 id=label9 style="CURSOR: default; HEIGHT: 51px; POSITION: absolute; LEFT: 325px; Z-INDEX: 78; DISPLAY: block; TOP: 20px; WIDTH: 81px" for=edit2 elementtype="32" name="edit2">
<SELECT tabIndex=77 id=edit2 style="POSITION: absolute; LEFT: 0px; DISPLAY: block; TOP: 29px; WIDTH: 80px" size=1 persistentuniqueid="compUid_18" boundtovariable="1" vspace="0" indeterminate="false" CHECKED="false" width="0" loop="1" maxLength="5" hspace="0" height="103221052" readOnly="false" start="fileopen" defaultlocation="0,0,22,81" name="edit2"></SELECT><B>Fiscal Year</B></LABEL>
<LABEL tabIndex=78 id=label10 style="CURSOR: default; HEIGHT: 51px; POSITION: absolute; LEFT: 425px; Z-INDEX: 80; DISPLAY: block; TOP: 20px; WIDTH: 135px" for=edit3 persistentuniqueid="compUid_41" elementtype="32" name="edit3">
<SELECT tabIndex=79 id=edit3 style="POSITION: absolute; LEFT: 0px; TOP: 29px; WIDTH: 141px" size=1 persistentuniqueid="compUid_19" boundtovariable="1" vspace="0" indeterminate="false" CHECKED="false" width="0" loop="1" maxLength="5" hspace="0" height="102892868" readOnly="false" start="fileopen" defaultlocation="0,0,22,81" defaultselection="1" name="edit3">
<OPTION selected value=01 displaytext="01 - July" noinput="0">01 - July</OPTION>
<OPTION value=02 displaytext="02 - August" noinput="0">02 - August</OPTION>
<OPTION value=03 displaytext="03 - September" noinput="0">03 - September</OPTION>
<OPTION value=04 displaytext="04 - October" noinput="0">04 - October</OPTION>
<OPTION value=05 displaytext="05 - November" noinput="0">05 - November</OPTION>
<OPTION value=06 displaytext="06 - December" noinput="0">06 - December</OPTION>
<OPTION value=07 displaytext="07 - January" noinput="0">07 - January</OPTION>
<OPTION value=08 displaytext="08 - February" noinput="0">08 - February</OPTION>
<OPTION value=09 displaytext="09 - March" noinput="0">09 - March</OPTION>
<OPTION value=10 displaytext="10 - April" noinput="0">10 - April</OPTION>
<OPTION value=11 displaytext="11 - May" noinput="0">11 - May</OPTION>
<OPTION value=12 displaytext="12 - June" noinput="0">12 - June</OPTION>
<OPTION value=13 displaytext="13 - Year End Adj 1" noinput="0">13 - Year End Adj 1</OPTION>
<OPTION value=14 displaytext="14 - Year End Adj 2" noinput="0">14 - Year End Adj 2</OPTION></SELECT><B>Fiscal Period</B></LABEL>
<LABEL tabIndex=80 id=pane6 style="CURSOR: default; HEIGHT: 51px; POSITION: absolute; LEFT: 324px; Z-INDEX: 81; DISPLAY: none; TOP: 90px; WIDTH: 80px" for=edit4 persistentuniqueid="compUid_23" elementtype="32" name="edit4">
<B id=ITEM10 style="DISPLAY: none" persistentuniqueid="compUid_25">Fund</B>
<INPUT tabIndex=81 onkeyup="return autoTab(this,5,event);" id=edit4 style="HEIGHT: 22px; POSITION: absolute; LEFT: 0px; Z-INDEX: 82; DISPLAY: none; TOP: 23px; WIDTH: 81px" maxLength=5 size=5 persistentuniqueid="compUid_26" name="edit4"></LABEL>
<LABEL tabIndex=82 id=pane7 style="CURSOR: default; HEIGHT: 51px; POSITION: absolute; LEFT: 425px; Z-INDEX: 83; DISPLAY: none; TOP: 90px; WIDTH: 80px" for=edit5 persistentuniqueid="compUid_27" elementtype="32" name="edit5">
<B id=ITEM20 style="DISPLAY: none" persistentuniqueid="compUid_35">Account</B>
<INPUT tabIndex=82 onkeyup="return autoTab(this,5,event);" id=edit5 style="HEIGHT: 22px; POSITION: absolute; LEFT: 0px; Z-INDEX: 82; DISPLAY: none; TOP: 23px; WIDTH: 81px" maxLength=5 size=5 persistentuniqueid="compUid_29" name="edit5"></LABEL> </FORM>
<SPAN tabIndex=84 id=checkbox1 contentEditable=false style="FONT-SIZE: 11pt; HEIGHT: 21px; FONT-FAMILY: Arial; POSITION: absolute; FONT-WEIGHT: bold; LEFT: 320px; Z-INDEX: 85; DISPLAY: block; TOP: 95px; WIDTH: 191px" persistentuniqueid="compUid_36" elementtype="11" columns="1" groupChildren="1" defaultselection="1" name="checkbox1">
<TABLE contentEditable=false style="FONT-SIZE: 11pt; HEIGHT: 100%; FONT-WEIGHT: bold; WIDTH: 100%" cellSpacing=0 cellPadding=0>
<TBODY>
<TR>
<TD noWrap>
<LABEL id=checkbox1_LABEL_0 style="CURSOR: default" for=checkbox1_0>
<INPUT tabIndex=84 id=checkbox1_0 type=checkbox value=Y displaytext="Exclude ACCT 1099" noinput="0" name="checkbox1">Exclude ACCT 1099</LABEL></TD></TR></TBODY></TABLE></SPAN></FIELDSET>
<SPAN tabIndex=83 id=line3 style="FONT-SIZE: 1pt; HEIGHT: 4px; POSITION: absolute; LEFT: 0px; Z-INDEX: 84; TOP: 406px; WIDTH: 1220px; BACKGROUND-COLOR: black" persistentuniqueid="compUid_37" elementtype="5"></SPAN>
<INPUT id=layoutinfo style="POSITION: absolute; LEFT: -100px; TOP: -100px" type=hidden resourcectrlids="image1;form2Submit;form2Reset">
<INPUT id=ibiapp_app style="POSITION: absolute; LEFT: -100px; TOP: -100px" type=hidden value=ban_finance name="ibiapp_app">
<INPUT id=ibic_server style="POSITION: absolute; LEFT: -100px; TOP: -100px" type=hidden value=EDASERVE isdataserversarea="1" name="ibic_server">
<xml id=focus_xmlelement>
<script type="text/xml" nextelementuniquenumber="3">
<rootxmlnode top="100" left="10" width="150" height="130" focoption="FOC_NONE">
<requests nextrequestsid="15">
<request requestid="14" sourcetype="typeFex" targettype="iframe" targetname="iframe1" ibif_ex="fin_trial_balance_call_ban.fex" activereport="0" reportcolumns="" ibiapp_app="ban_finance"></request></requests>
<variables>
<variable parametercreatedinreslay="0" displayfield="REPORT" format="" field="REPORT" file="vendor_type.mas" desc="REPORT" datatype="0" operation="" default="0" name="REPORT" textvarname="" accept="0" type="unresolved" select="0" min="" max="" controltype="7" create="1" top="70" left="250" width="60" height="20" inbinding="1">
<link linktype="default" from="compUid_8">
<condition default="1" name="Default" whattodowithcontrol="4" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0">
<data_info displayfield="REPORT" datafield="REPORT" datasource="" datatype="0" selectedvalue="0" operation="" slider_range_from="" slider_range_to="" linktype="none" sourcetype="typeMaster">
<static_values>
<static value="0" display="0" selected="1" noinput="0"></static></static_values></data_info></condition></link>
<requestid id="14"></requestid></variable>
<variable parametercreatedinreslay="0" displayfield="FMT" format="" field="FMT" file="vendor_type.mas" desc="FMT" datatype="0" operation="" default="EXL2K" name="FMT" textvarname="" accept="0" type="default" select="0" min="" max="" controltype="7" create="1" top="70" left="140" width="60" height="20" inbinding="1">
<link linktype="default" from="compUid_4">
<condition default="1" name="Default" whattodowithcontrol="4" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0">
<data_info displayfield="FMT" datafield="FMT" datasource="vendor_type.mas" datatype="0" selectedvalue="EXL2K" operation="" slider_range_from="" slider_range_to="" linktype="none" sourcetype="typeMaster">
<static_values>
<static value="EXL2K" display="EXL2K" selected="1" noinput="0"></static></static_values></data_info></condition></link>
<requestid id="14"></requestid></variable>
<variable controltype="7" parametercreatedinreslay="0" type="default" desc="FY" name="FY" default="2011" textvarname="" accept="0" select="0" create="1" top="70" left="360" width="60" height="20" inbinding="1">
<link linktype="default" from="compUid_18">
<condition default="1" name="Default" whattodowithcontrol="4" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0">
<data_info displayfield="FY" datafield="FY" datasource="" datatype="0" selectedvalue="2011" operation="" slider_range_from="" slider_range_to="" linktype="none" sourcetype="typeMaster">
<static_values>
<static value="2011" display="2011" selected="1" noinput="0"></static></static_values></data_info></condition></link>
<requestid id="14"></requestid></variable>
<variable controltype="7" parametercreatedinreslay="0" type="default" desc="FP" name="FP" default="09" textvarname="" accept="0" select="0" create="1" top="70" left="470" width="60" height="20" inbinding="1">
<link linktype="default" from="compUid_19">
<condition default="1" name="Default" whattodowithcontrol="4" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0">
<data_info displayfield="FP" datafield="FP" datasource="" datatype="0" selectedvalue="09" operation="" slider_range_from="" slider_range_to="" linktype="none" sourcetype="typeMaster">
<static_values>
<static value="09" display="09" selected="1" noinput="0"></static></static_values></data_info></condition></link>
<requestid id="14"></requestid></variable>
<variable controltype="7" parametercreatedinreslay="0" type="default" desc="FUND" name="FUND" default=" " textvarname="" accept="0" select="0" create="1" top="70" left="580" width="60" height="20" inbinding="1">
<link linktype="default" from="compUid_26">
<condition default="1" name="Default" whattodowithcontrol="4" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0">
<data_info displayfield="FUND" datafield="FUND" datasource="" 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="14"></requestid></variable>
<variable controltype="7" parametercreatedinreslay="0" type="default" desc="ACCOUNT" name="ACCOUNT" default="1258" textvarname="" accept="0" select="0" create="1" top="70" left="690" width="60" height="20" inbinding="1">
<link linktype="default" from="compUid_29">
<condition default="1" name="Default" whattodowithcontrol="4" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0">
<data_info displayfield="ACCOUNT" datafield="ACCOUNT" datasource="" datatype="0" selectedvalue="1258" operation="" slider_range_from="" slider_range_to="" linktype="none" sourcetype="typeMaster">
<static_values>
<static value="1258" display="1258" selected="1" noinput="0"></static></static_values></data_info></condition></link>
<requestid id="14"></requestid></variable>
<variable controltype="7" parametercreatedinreslay="0" type="default" desc="EXL_1099" name="EXL_1099" default="N" textvarname="" accept="0" select="0" create="1" top="70" left="800" width="60" height="20" inbinding="1">
<link linktype="default" from="compUid_36">
<condition default="1" name="Default" whattodowithcontrol="4" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0">
<data_info displayfield="EXL_1099" datafield="EXL_1099" datasource="" datatype="0" selectedvalue="N" operation="" slider_range_from="" slider_range_to="" linktype="none" sourcetype="typeMaster">
<static_values>
<static value="N" display="N" selected="1" noinput="0"></static></static_values></data_info></condition></link>
<requestid id="14"></requestid></variable>
<variable controltype="7" parametercreatedinreslay="0" type="unresolved" desc="nbsp" name="nbsp" 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="nbsp" datafield="nbsp" datasource="" datatype="0" selectedvalue="" operation="" slider_range_from="" slider_range_to=""></data_info></condition></link>
<requestid id="14"></requestid></variable></variables>
<input_controls>
<input_control bindcontrolid="compUid_1" elementtype="7" name="edit1" id="edit1" multiple="0" inbinding="1" onetimepopulated="1" unresolved="0" top="20" left="30" width="60" height="20">
<link linktype="default">
<condition default="1" name="Default" whattodowithcontrol="0" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0">
<data_info accept="0" sourcetype="typeMaster" checkForDuplicateValues="0">
<static_values>
<static value="Finance Balance Reports (Banner Tables)" display="Finance Balance Reports (Banner Tables)" selected="1" noinput="0"></static></static_values></data_info></condition></link></input_control>
<input_control bindcontrolid="compUid_4" elementtype="12" name="radio1" id="radio1" multiple="0" onetimepopulated="1" inbinding="1" unresolved="0" top="20" left="140" width="60" height="20">
<link linktype="default">
<condition default="1" name="Default" whattodowithcontrol="0" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0">
<data_info datatype="0" datasource="" addalloption="0" sourcetype="typeMaster" cacheruntimedata="0" accept="0" selectedvalue="PDF" operation="NONE" modifiedrequest="1" checkForDuplicateValues="0">
<static_values>
<static value="EXL2K" display="EXCEL" selected="1"></static>
<static value="PDF" display="PDF" selected="0"></static>
<static value="EXL2K" display="CSV (NA yet)" selected="0"></static>
<static value="HTML" display="HTML (Balance Sheet only)" selected="0"></static>
<static value="EXL2K" display="TAB Delimited (NA yet)" selected="0"></static></static_values></data_info></condition></link></input_control>
<input_control bindcontrolid="compUid_8" elementtype="12" name="radio2" id="radio2" multiple="0" onetimepopulated="1" inbinding="1" unresolved="0" top="20" left="250" width="60" height="20">
<link linktype="default">
<condition default="1" name="Default" whattodowithcontrol="0" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0">
<data_info datatype="0" datasource="" addalloption="0" sourcetype="typeMaster" cacheruntimedata="0" accept="0" selectedvalue="SPRI" operation="NONE" modifiedrequest="1" checkForDuplicateValues="0">
<static_values>
<static value="0" display="Trial Balance - Summary/Detail" selected="1" noinput="0"></static>
<static value="1" display="Fiscal Year Beginning Balance" selected="0" noinput="0"></static>
<static value="2" display="Balance Sheet Detail" selected="0" noinput="0"></static></static_values></data_info></condition></link></input_control>
<input_control bindcontrolid="compUid_18" elementtype="8" requiredfield="0" name="edit2" id="edit2" multiple="0" inbinding="1" unresolved="0" onetimepopulated="0" top="20" left="360" width="60" height="20">
<link linktype="default">
<condition default="1" name="Default" whattodowithcontrol="0" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0">
<data_info datatype="1" datasource="fin_get_gl_fiscal_year.fex" addalloption="0" sourcetype="typeFex" cacheruntimedata="0" accept="0" selectedvalue="11" operation="NONE" displayfield="FISCAL_YEAR" datafield="FISCAL_YEAR" ibiapp_app="ban_finance" modifiedrequest="1" checkForDuplicateValues="0">
<![CDATA[]]>
</data_info></condition></link></input_control>
<input_control bindcontrolid="compUid_19" elementtype="8" requiredfield="0" name="edit3" id="edit3" multiple="0" inbinding="1" unresolved="0" onetimepopulated="1" top="20" left="470" width="60" height="20">
<link linktype="default" persistentuniqueid="compUid_1">
<condition default="1" name="Default" whattodowithcontrol="0" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0">
<data_info datatype="0" datasource="sqlout.mas" addalloption="0" sourcetype="typeMaster" cacheruntimedata="0" accept="0" selectedvalue="01" operation="NONE" modifiedrequest="0" checkForDuplicateValues="0">
<![CDATA[]]>
<static_values>
<static value="01" display="01 - July" selected="0" noinput="0"></static>
<static value="02" display="02 - August" selected="0" noinput="0"></static>
<static value="03" display="03 - September" selected="0" noinput="0"></static>
<static value="04" display="04 - October" selected="0" noinput="0"></static>
<static value="05" display="05 - November" selected="0" noinput="0"></static>
<static value="06" display="06 - December" selected="0" noinput="0"></static>
<static value="07" display="07 - January" selected="0" noinput="0"></static>
<static value="08" display="08 - February" selected="0" noinput="0"></static>
<static value="09" display="09 - March" selected="0" noinput="0"></static>
<static value="10" display="10 - April" selected="0" noinput="0"></static>
<static value="11" display="11 - May" selected="0" noinput="0"></static>
<static value="12" display="12 - June" selected="0" noinput="0"></static>
<static value="13" display="13 - Year End Adj 1" selected="0" noinput="0"></static>
<static value="14" display="14 - Year End Adj 2" selected="0" noinput="0"></static></static_values></data_info></condition></link></input_control>
<input_control bindcontrolid="compUid_26" elementtype="7" name="edit4" id="edit4" multiple="0" onetimepopulated="1" inbinding="1" top="20" left="580" width="60" height="20" unresolved="0">
<link linktype="default">
<condition default="1" name="Default" whattodowithcontrol="0" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0">
<data_info accept="0" datasource="" displayfield="" datafield="" datatype="0" sourcetype="typeMaster" selectedvalue="" addalloption="0" operation="NONE" checkForDuplicateValues="0">
<![CDATA[]]>
<static_values>
<static value="" display="" selected="1"></static></static_values></data_info></condition></link></input_control>
<input_control bindcontrolid="compUid_29" elementtype="7" name="edit5" id="edit5" multiple="0" inbinding="1" onetimepopulated="1" top="20" left="690" width="60" height="20" unresolved="0">
<link linktype="default">
<condition default="1" name="Default" whattodowithcontrol="0" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0">
<data_info accept="0" datasource="" displayfield="" datafield="" datatype="0" sourcetype="typeMaster" selectedvalue="" addalloption="0" operation="NONE" checkForDuplicateValues="0">
<![CDATA[]]>
<static_values>
<static value="" display="" selected="1"></static></static_values></data_info></condition></link></input_control>
<input_control bindcontrolid="compUid_36" onetimepopulated="1" name="checkbox1" id="checkbox1" multiple="0" elementtype="11" top="20" left="800" width="60" height="20" inbinding="1">
<link linktype="default" persistentuniqueid="compUid_2">
<condition default="1" name="Default" whattodowithcontrol="0" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0">
<data_info sourcetype="typeMaster" modifiedrequest="0" datatype="0" selectedvalue="N" accept="0" addalloption="0" operation="NONE" checkForDuplicateValues="0">
<static_values>
<static value="Y" display="Exclude ACCT 1099" selected="0" noinput="0"></static></static_values></data_info></condition></link></input_control></input_controls>
<other_bound_objects></other_bound_objects></rootxmlnode></script>
</xml></BODY>
<SCRIPT id=IBI_loader type=text/javascript>
doBeforeLoad();
</SCRIPT>
</HTML>
hth
Tom Flynn WebFOCUS 8.1.05 - PROD/QA DB2 - AS400 - Mainframe
Posts: 1972 | Location: Centennial, CO | Registered: January 31, 2006
IP
Platinum Member WOW! Thanks Tom! I was just fixing to ask for an example. I will look this over and see if I can tweak it to work for me.
I will post the code when I get it working.
Thanks
Again
WebFOCUS 8105m Windows, All Outputs
Platinum Member Ok, I worked with this yesterday but couldn't get it to work. You are using 7.7 and I am still using 7.6.4 and the HTML is altogether different. I just built the screen without the toggles. If they don't want to select something they will just leave the dropdown set to None.
Thank again Tom
JV
WebFOCUS 8105m Windows, All Outputs
Please Wait. Your request is being processed...
Read-Only TopicCopyright © 1996-2020 Information Builders