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!
Gold member posted October 02, 2011 07:10 PM
Hi,
I have chaining requirement and the values of the CITY doesnt change when I change the SELECTED STATE. Please see the below code.
<HTML>
<HEAD>
<META id=mycharsetmeta http-equiv=Content-Type content="text/html; charset=ISO-8859-1">
<META id=Generation content="Created in release 7702, 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 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);
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" persistentuniqueid="compUid_1" edaconnectionrequired="true" thumbnailscale="4" elementtype="21" nextelementuniquenumber="52">
<IFRAME id=report1 style="Z-INDEX: 1; LEFT: 60px; WIDTH: 1030px; POSITION: absolute; TOP: 191px; HEIGHT: 600px" tabIndex=1 persistentuniqueid="compUid_16" elementtype="2" requests_list="0" autoExecute="false" name="report1"></IFRAME>
<SPAN id=customselect1 style="Z-INDEX: 11; LEFT: 580px; WIDTH: 400px; POSITION: absolute; TOP: 40px; HEIGHT: 130px" tabIndex=10 persistentuniqueid="compUid_40" elementtype="36" _downbutton="compUid_39" _upbutton="compUid_38" _removebutton="compUid_37" _addbutton="compUid_36" _selectto="compUid_34" _selectfrom="compUid_35" dlistaddevents="1" defaultselection="1" defaultlocation="0,0,59,134">
<SELECT id=customselect1_selectfrom style="Z-INDEX: 12; LEFT: 0px; WIDTH: 178px; POSITION: absolute; TOP: 0px; HEIGHT: 130px" tabIndex=11 multiple size=3 persistentuniqueid="compUid_35" name="customselect1_selectfrom"></SELECT>
<INPUT id=customselect1_addbutton style="BACKGROUND-POSITION: center center; Z-INDEX: 13; LEFT: 188px; BACKGROUND-IMAGE: url(htmlpathsub/javaassist/ibi/html/describe/move_right_16.png); WIDTH: 24px; BACKGROUND-REPEAT: no-repeat; POSITION: absolute; TOP: 23px; HEIGHT: 20px; BACKGROUND-COLOR: lavender" tabIndex=12 type=button value=" " persistentuniqueid="compUid_36" StyleBack_UserSuppliedFullPath="1" name="button1">
<INPUT id=customselect1_removebutton style="BACKGROUND-POSITION: center center; Z-INDEX: 14; LEFT: 188px; BACKGROUND-IMAGE: url(htmlpathsub/javaassist/ibi/html/describe/move_left_16.png); WIDTH: 24px; BACKGROUND-REPEAT: no-repeat; POSITION: absolute; TOP: 43px; HEIGHT: 20px; BACKGROUND-COLOR: lavender" tabIndex=13 type=button value=" " persistentuniqueid="compUid_37" StyleBack_UserSuppliedFullPath="1" name="button2">
<SELECT id=customselect1_selectto style="Z-INDEX: 15; LEFT: 222px; WIDTH: 178px; POSITION: absolute; TOP: 0px; HEIGHT: 130px" tabIndex=14 size=3 persistentuniqueid="compUid_34" name="customselect1_selectto"></SELECT>
<INPUT id=customselect1_upbutton style="BACKGROUND-POSITION: center center; Z-INDEX: 16; LEFT: 188px; BACKGROUND-IMAGE: url(htmlpathsub/javaassist/ibi/html/describe/move_up_16.png); WIDTH: 24px; BACKGROUND-REPEAT: no-repeat; POSITION: absolute; TOP: 68px; HEIGHT: 20px; BACKGROUND-COLOR: lavender" onclick='moveSelectedItems("compUid_34", "true")' tabIndex=15 type=button value=" " persistentuniqueid="compUid_38" StyleBack_UserSuppliedFullPath="1" buddyuniqueid="compUid_34" name="button3">
<INPUT id=customselect1_downbutton style="BACKGROUND-POSITION: center center; Z-INDEX: 17; LEFT: 188px; BACKGROUND-IMAGE: url(htmlpathsub/javaassist/ibi/html/describe/move_down_16.png); WIDTH: 24px; BACKGROUND-REPEAT: no-repeat; POSITION: absolute; TOP: 88px; HEIGHT: 20px; BACKGROUND-COLOR: lavender" onclick='moveSelectedItems("compUid_34", "")' tabIndex=16 type=button value=" " persistentuniqueid="compUid_39" StyleBack_UserSuppliedFullPath="1" buddyuniqueid="compUid_34" name="button4"></SPAN>
<SELECT id=listbox6 style="Z-INDEX: 19; LEFT: 1010px; WIDTH: 100px; POSITION: absolute; TOP: 50px; HEIGHT: 54px" tabIndex=18 size=3 persistentuniqueid="compUid_45" defaultselection="1" name="listbox6"></SELECT>
<SPAN id=text1 style="Z-INDEX: 20; LEFT: 1010px; WIDTH: 50px; POSITION: absolute; TOP: 20px; HEIGHT: 19px" tabIndex=19>CITY</SPAN>
<SPAN id=text2 style="Z-INDEX: 21; LEFT: 580px; WIDTH: 160px; POSITION: absolute; TOP: 10px; HEIGHT: 20px" tabIndex=20>AVAILABLE STATES</SPAN>
<SPAN id=text3 style="Z-INDEX: 22; LEFT: 810px; WIDTH: 180px; POSITION: absolute; TOP: 10px; HEIGHT: 20px" tabIndex=21>SELECTED STATES</SPAN>
<INPUT id=layoutinfo style="LEFT: -100px; POSITION: absolute; TOP: -100px" type=hidden resourcectrlids="customselect1_addbutton;customselect1_removebutton;customselect1_upbutton;customselect1_downbutton">
<INPUT id=ibiapp_app style="LEFT: -100px; POSITION: absolute; TOP: -100px" type=hidden value=nyclaw name="ibiapp_app">
<INPUT id=ibic_server style="LEFT: -100px; POSITION: absolute; TOP: -100px" type=hidden value=EDASERVE isdataserversarea="1" name="ibic_server">
<xml id=focus_xmlelement>
<script type="text/xml" nextelementuniquenumber="34">
<rootxmlnode focoption="FOC_NONE" top="100" left="10" width="150" height="130">
<variables>
<variable controltype="8" parametercreatedinreslay="0" type="unresolved" desc="ST" name="ST" default="" textvarname="" accept="0" select="0" create="1" top="70" left="250" width="60" height="20" inbinding="1">
<link linktype="default" persistentuniqueid="compUid_28" from="compUid_40">
<condition default="1" name="Default" whattodowithcontrol="4" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0">
<data_info checkForDuplicateValues="0" displayfield="ST" ibiformat="A02" datafield="ST" datasource="GGSALES.mas" datatype="1" selectedvalue="" operation="" slider_range_from="" slider_range_to="" previewvalue="" sourcetype="typeMaster" linktype="none"></data_info></condition></link>
<requestid id="0"></requestid></variable>
<variable controltype="8" parametercreatedinreslay="0" type="unresolved" desc="CITY" name="CITY" default="" textvarname="" accept="0" select="0" create="1" top="70" left="360" width="60" height="20" inbinding="1">
<link linktype="default" from="compUid_45">
<condition default="1" name="Default" whattodowithcontrol="4" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0">
<data_info checkForDuplicateValues="0" displayfield="CITY" ibiformat="A20" datafield="CITY" datasource="GGSALES.mas" datatype="1" selectedvalue="" operation="" slider_range_from="" slider_range_to="" previewvalue=""></data_info></condition></link>
<requestid id="0"></requestid></variable></variables>
<input_controls>
<input_control bindcontrolid="compUid_40" elementtype="36" name="customselect1" id="customselect1" multiple="1" inbinding="1" top="20" left="250" width="60" height="20" onetimepopulated="0">
<link linktype="default" persistentuniqueid="compUid_27">
<condition default="1" name="Default" whattodowithcontrol="0" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0">
<data_info checkForDuplicateValues="0" sourcetype="typeMaster" datasource="GGSALES.mas" displayfield="ST" datafield="ST" datatype="1" selectedvalue="" ibiformat="A02" accept="0" addalloption="0" modifiedrequest="0" operation="NONE">
<![CDATA[TABLE FILE GGSALES
SUM FST.ST
BY ST
-*insert_filters_here
ON TABLE PCHOLD FORMAT XML
END
]]></data_info></condition></link></input_control>
<input_control bindcontrolid="compUid_45" elementtype="9" name="listbox6" id="listbox6" multiple="0" inbinding="1" top="20" left="360" width="60" height="20" onetimepopulated="0">
<link linktype="default" persistentuniqueid="compUid_32" from="compUid_40">
<condition default="1" name="Default" whattodowithcontrol="0" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0" resolveparameterfq="ST" resolveparameter="ST">
<data_info checkForDuplicateValues="0" sourcetype="typeMaster" datasource="GGSALES.mas" displayfield="CITY" datafield="CITY" datatype="1" selectedvalue="" ibiformat="A20" accept="0" addalloption="0" operation="NONE">
<![CDATA[TABLE FILE GGSALES
SUM FST.CITY
BY CITY
-*insert_filters_here
ON TABLE PCHOLD FORMAT XML
END
]]></data_info></condition></link></input_control></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" compoundreport="0" reportcolumns="" reportrealcolumns="" ibiapp_app="">
<![CDATA[TABLE FILE GGSALES
SUM
GGSALES.SALES01.DOLLARS
BY GGSALES.SALES01.CATEGORY
BY GGSALES.SALES01.PCD
BY GGSALES.SALES01.PRODUCT
BY GGSALES.SALES01.REGION
BY GGSALES.SALES01.ST
BY GGSALES.SALES01.CITY
BY GGSALES.SALES01.STCD
WHERE ( GGSALES.SALES01.ST EQ '&ST.(FIND ST IN GGSALES).ST.' ) AND ( GGSALES.SALES01.CITY EQ '&CITY.(FIND CITY IN GGSALES).CITY.' );
ON TABLE SET PAGE-NUM NOLEAD
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> WF 8.2.0.1, MRE, BI Dashboard, Self Service, Dev Studio, MS Windows XP SP1, Apache Tomcat/6.0.20, Oracle 11 g, I.E. 9 Output formats: HTML, Excel 2000 and PDF,Active Reports
Posts: 60 | Location: USA | Registered: April 07, 2011
IP
Expert Your code worked for me when I simply copy-pasted it in a v7702 html file.
This is the result of actually editing the code in v7702 - that's a little different than running a v76 created file in v77 - you have to edit and save it. The HTML code changes, which may be what makes it work. All I did here was change the size of the City select list:
<!-- 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 7702, 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" persistentuniqueid="compUid_1" edaconnectionrequired="true" thumbnailscale="4" elementtype="21" nextelementuniquenumber="52">
<IFRAME style="Z-INDEX: 1; POSITION: absolute; WIDTH: 1030px; HEIGHT: 600px; TOP: 191px; LEFT: 60px" id=report1 tabIndex=1 persistentuniqueid="compUid_16" elementtype="2" requests_list="0" autoExecute="false" name="report1"></IFRAME>
<SPAN style="Z-INDEX: 11; POSITION: absolute; WIDTH: 400px; HEIGHT: 130px; TOP: 40px; LEFT: 60px" id=customselect1 tabIndex=10 persistentuniqueid="compUid_40" elementtype="36" _downbutton="compUid_39" _upbutton="compUid_38" _removebutton="compUid_37" _addbutton="compUid_36" _selectto="compUid_34" _selectfrom="compUid_35" dlistaddevents="1" defaultselection="1" defaultlocation="0,0,59,134">
<SELECT style="Z-INDEX: 12; POSITION: absolute; WIDTH: 178px; HEIGHT: 130px; TOP: 0px; LEFT: 0px" id=customselect1_selectfrom tabIndex=11 multiple size=5 persistentuniqueid="compUid_35" defaultselection="1" name="customselect1_selectfrom"></SELECT>
<INPUT style="BACKGROUND-IMAGE: url(htmlpathsub/javaassist/ibi/html/describe/move_right_16.png); Z-INDEX: 13; POSITION: absolute; BACKGROUND-COLOR: lavender; WIDTH: 24px; BACKGROUND-REPEAT: no-repeat; BACKGROUND-POSITION: center center; HEIGHT: 20px; TOP: 23px; LEFT: 188px" id=customselect1_addbutton tabIndex=12 value=" " type=button persistentuniqueid="compUid_36" StyleBack_UserSuppliedFullPath="1" name="button1">
<INPUT style="BACKGROUND-IMAGE: url(htmlpathsub/javaassist/ibi/html/describe/move_left_16.png); Z-INDEX: 14; POSITION: absolute; BACKGROUND-COLOR: lavender; WIDTH: 24px; BACKGROUND-REPEAT: no-repeat; BACKGROUND-POSITION: center center; HEIGHT: 20px; TOP: 43px; LEFT: 188px" id=customselect1_removebutton tabIndex=13 value=" " type=button persistentuniqueid="compUid_37" StyleBack_UserSuppliedFullPath="1" name="button2">
<SELECT style="Z-INDEX: 15; POSITION: absolute; WIDTH: 178px; HEIGHT: 130px; TOP: 0px; LEFT: 220px" id=customselect1_selectto tabIndex=14 size=5 persistentuniqueid="compUid_34" defaultselection="1" name="customselect1_selectto"></SELECT>
<INPUT style="BACKGROUND-IMAGE: url(htmlpathsub/javaassist/ibi/html/describe/move_up_16.png); Z-INDEX: 16; POSITION: absolute; BACKGROUND-COLOR: lavender; WIDTH: 24px; BACKGROUND-REPEAT: no-repeat; BACKGROUND-POSITION: center center; HEIGHT: 20px; TOP: 68px; LEFT: 188px" id=customselect1_upbutton tabIndex=15 onclick='moveSelectedItems("compUid_34", "true")' value=" " type=button persistentuniqueid="compUid_38" StyleBack_UserSuppliedFullPath="1" buddyuniqueid="compUid_34" name="button3">
<INPUT style="BACKGROUND-IMAGE: url(htmlpathsub/javaassist/ibi/html/describe/move_down_16.png); Z-INDEX: 17; POSITION: absolute; BACKGROUND-COLOR: lavender; WIDTH: 24px; BACKGROUND-REPEAT: no-repeat; BACKGROUND-POSITION: center center; HEIGHT: 20px; TOP: 88px; LEFT: 188px" id=customselect1_downbutton tabIndex=16 onclick='moveSelectedItems("compUid_34", "")' value=" " type=button persistentuniqueid="compUid_39" StyleBack_UserSuppliedFullPath="1" buddyuniqueid="compUid_34" name="button4"></SPAN>
<SELECT style="Z-INDEX: 19; POSITION: absolute; WIDTH: 220px; HEIGHT: 130px; TOP: 40px; LEFT: 490px" id=listbox6 tabIndex=18 size=5 persistentuniqueid="compUid_45" defaultselection="1" name="listbox6"></SELECT>
<SPAN style="Z-INDEX: 20; POSITION: absolute; WIDTH: 50px; HEIGHT: 19px; TOP: 0px; LEFT: 490px" id=text1 tabIndex=19 defaultselection="1">CITY</SPAN>
<SPAN style="Z-INDEX: 21; POSITION: absolute; WIDTH: 160px; HEIGHT: 20px; TOP: 0px; LEFT: 60px" id=text2 tabIndex=20>AVAILABLE STATES</SPAN>
<SPAN style="Z-INDEX: 22; POSITION: absolute; WIDTH: 180px; HEIGHT: 20px; TOP: 0px; LEFT: 290px" id=text3 tabIndex=21 defaultselection="1">SELECTED STATES</SPAN>
<INPUT style="POSITION: absolute; TOP: -100px; LEFT: -100px" id=layoutinfo type=hidden resourcectrlids="customselect1_addbutton;customselect1_removebutton;customselect1_upbutton;customselect1_downbutton">
<INPUT style="POSITION: absolute; TOP: -100px; LEFT: -100px" id=ibiapp_app value=test type=hidden name="ibiapp_app">
<INPUT style="POSITION: absolute; TOP: -100px; LEFT: -100px" id=ibic_server value=EDASER77 type=hidden isdataserversarea="1" name="ibic_server">
<xml id=focus_xmlelement>
<script type="text/xml" nextelementuniquenumber="34">
<rootxmlnode focoption="FOC_NONE" top="100" left="10" width="150" height="130">
<variables>
<variable controltype="8" parametercreatedinreslay="0" type="unresolved" desc="ST" name="ST" default="" textvarname="" accept="0" select="0" create="1" top="70" left="30" width="60" height="20" inbinding="1">
<link linktype="default" persistentuniqueid="compUid_28" from="compUid_40">
<condition default="1" name="Default" whattodowithcontrol="4" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0">
<data_info checkForDuplicateValues="0" displayfield="ST" ibiformat="A02" datafield="ST" datasource="GGSALES.mas" datatype="1" selectedvalue="" operation="" slider_range_from="" slider_range_to="" previewvalue="" sourcetype="typeMaster" linktype="none"></data_info></condition></link>
<requestid id="0"></requestid></variable>
<variable controltype="8" parametercreatedinreslay="0" type="unresolved" desc="CITY" name="CITY" default="" textvarname="" accept="0" select="0" create="1" top="70" left="140" width="60" height="20" inbinding="1">
<link linktype="default" from="compUid_45">
<condition default="1" name="Default" whattodowithcontrol="4" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0">
<data_info checkForDuplicateValues="0" displayfield="CITY" ibiformat="A20" datafield="CITY" datasource="GGSALES.mas" datatype="1" selectedvalue="" operation="" slider_range_from="" slider_range_to="" previewvalue=""></data_info></condition></link>
<requestid id="0"></requestid></variable></variables>
<input_controls>
<input_control bindcontrolid="compUid_40" elementtype="36" name="customselect1" id="customselect1" multiple="1" inbinding="1" top="20" left="30" width="60" height="20" onetimepopulated="0">
<link linktype="default" persistentuniqueid="compUid_27">
<condition default="1" name="Default" whattodowithcontrol="0" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0">
<data_info checkForDuplicateValues="0" sourcetype="typeMaster" datasource="GGSALES.mas" displayfield="ST" datafield="ST" datatype="1" selectedvalue="" ibiformat="A02" accept="0" addalloption="0" modifiedrequest="0" operation="NONE">
<![CDATA[TABLE FILE GGSALES
SUM FST.ST
BY ST
-*insert_filters_here
ON TABLE PCHOLD FORMAT XML
END
]]></data_info></condition></link></input_control>
<input_control bindcontrolid="compUid_45" elementtype="9" name="listbox6" id="listbox6" multiple="0" inbinding="1" top="20" left="140" width="60" height="20" onetimepopulated="0">
<link linktype="default" persistentuniqueid="compUid_32" from="compUid_40">
<condition default="1" name="Default" whattodowithcontrol="0" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0" resolveparameterfq="ST" resolveparameter="ST">
<data_info checkForDuplicateValues="0" sourcetype="typeMaster" datasource="GGSALES.mas" displayfield="CITY" datafield="CITY" datatype="1" selectedvalue="" ibiformat="A20" accept="0" addalloption="0" operation="NONE">
<![CDATA[TABLE FILE GGSALES
SUM FST.CITY
BY CITY
-*insert_filters_here
ON TABLE PCHOLD FORMAT XML
END
]]></data_info></condition></link></input_control></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" compoundreport="0" reportcolumns="" reportrealcolumns="" ibiapp_app="">
<![CDATA[TABLE FILE GGSALES
SUM
GGSALES.SALES01.DOLLARS
BY GGSALES.SALES01.CATEGORY
BY GGSALES.SALES01.PCD
BY GGSALES.SALES01.PRODUCT
BY GGSALES.SALES01.REGION
BY GGSALES.SALES01.ST
BY GGSALES.SALES01.CITY
BY GGSALES.SALES01.STCD
WHERE ( GGSALES.SALES01.ST EQ '&ST.(FIND ST IN GGSALES).ST.' ) AND ( GGSALES.SALES01.CITY EQ '&CITY.(FIND CITY IN GGSALES).CITY.' );
ON TABLE SET PAGE-NUM NOLEAD
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>
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
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005
IP
Gold member Please see the above image as the chaining values doesnt change when i change the Selected States the values corresponding the CITY doesnt change.
As mentioned by you in the mail the chaining still doesnt help me when changing the size of the list box in V7702M.
Please let me know if still have any ideas in this reagard.
WF 8.2.0.1, MRE, BI Dashboard, Self Service, Dev Studio, MS Windows XP SP1, Apache Tomcat/6.0.20, Oracle 11 g, I.E. 9 Output formats: HTML, Excel 2000 and PDF,Active Reports
Posts: 60 | Location: USA | Registered: April 07, 2011
IP
Gold member Francis,
Please see the belowimage as the chaining values doesnt change when i change the Selected States the values corresponding the CITY doesnt change.
As mentioned by you in the above mail the chaining still doesnt help me when changing the size of the list box in V7702M.
Please let me know if still have any ideas in this reagard.
WF 8.2.0.1, MRE, BI Dashboard, Self Service, Dev Studio, MS Windows XP SP1, Apache Tomcat/6.0.20, Oracle 11 g, I.E. 9 Output formats: HTML, Excel 2000 and PDF,Active Reports
Posts: 60 | Location: USA | Registered: April 07, 2011
IP
Expert It works for me. Did you open and edit the HTML in the v7.7.02 GUI Composer? You must do that before assuming it does not work.
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
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005
IP
Gold member Francis,
If i'm not wrong shouldn't the value of the CITY should change when I select the FL or GA state.
I do see that you are removing one of the STATE from the list and the values are populating.
My concern is when I have both FL and GA values in the "selected states" and I click either FL or GA I should have the corresponding values in the CITY drop down.
Regards,
Majid
WF 8.2.0.1, MRE, BI Dashboard, Self Service, Dev Studio, MS Windows XP SP1, Apache Tomcat/6.0.20, Oracle 11 g, I.E. 9 Output formats: HTML, Excel 2000 and PDF,Active Reports
Posts: 60 | Location: USA | Registered: April 07, 2011
IP
Expert The cities list box will show all cities for the states in the right-hand side of the double list box, with the first city selected. I don't think there's any more interaction between the two controls.
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
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005
IP
Gold member Francis,
I still need the requirement as mentioned above. Is there a way to achieve this..? Please advise..
Regards,
SAMM
WF 8.2.0.1, MRE, BI Dashboard, Self Service, Dev Studio, MS Windows XP SP1, Apache Tomcat/6.0.20, Oracle 11 g, I.E. 9 Output formats: HTML, Excel 2000 and PDF,Active Reports
Posts: 60 | Location: USA | Registered: April 07, 2011
IP
Please Wait. Your request is being processed...
Read-Only TopicCopyright © 1996-2020 Information Builders