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 July 09, 2011 12:28 PM
Hi a question.
I have made a standerd HTML page using the option 'New Guided Report Form'.
When I start de webpage and then the application on tab1 with 'AUDI' de application on tab2 is also started with the parameter 'AUDI'.
My intension was when I drilldown (tab1) on country I want that the application on tab1 and tab2 are been excecuted with the parameter &country (JAPAN).
Does anyone no how to do this?
My coding :
<!-- 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>
<LINK id=ITEM1 rel=stylesheet type=text/css href="htmlpathsub/javaassist/ibi/html/composer/themes/nonBindows/IBI-Themes/default.css" UserSuppliedFullPath="1">
<LINK id=IBI_TABBED_CSS rel=stylesheet type=text/css href="htmlpathsub/javaassist/ibi/html/composer/themes/nonBindows/IBI-Themes/tabbedtemplate.css" UserSuppliedFullPath="1">
<LINK id=IBI_THEME_CSS rel=stylesheet type=text/css href="htmlpathsub/javaassist/ibi/html/composer/themes/nonBindows/" UserSuppliedFullPath="1" desc="Plain">
<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" class=IBI_PageBg thumbnailscale="4" elementtype="21" tabfolderstrip="compUid_1" nextelementuniquenumber="2" layoutcssfiles="/ibi_html/javaassist/ibi/html/composer/themes/nonBindows/" templatedoclocked="1" layoutid="ibi_layout_1" guideddocument="0" edaconnectionrequired="true">
<DIV id="Template page1" class="IBIfield IBI_PageBg" title="" tabIndex=1 elementtype="34">
<DIV id="Top bar1" class="IBIfield IBI_Topbar" title="" tabIndex=2 elementtype="34">
<DIV id=Logo1 class="IBIfield IBI_TopbarColumn1" title="" tabIndex=3 elementtype="1"></DIV>
<DIV id="Top bar title1" class="IBIfield IBI_TopbarTitle" title="" tabIndex=4 elementtype="4">Topbar Title goes here</DIV>
<DIV id="Top bar info1" class="IBIfield IBI_TopbarColumn2" title="" tabIndex=5 elementtype="4">Topbar info goes here</DIV></DIV>
<DIV id="Page title1" class="IBIfield IBI_PageTitle" title="" tabIndex=6 elementtype="4">Page Title goes here</DIV>
<DIV id="Page description1" class="IBIfield IBI_Description" title="" tabIndex=7 elementtype="4">Description goes here</DIV>
<DIV id="Hyperlinks strip1" class="IBIfield IBI_HyperlinksBar" title=Hyperlinks tabIndex=8 elementtype="34" childid="Link">
<DIV id=Link1 class="IBIfield IBI_LinkItem" title="" tabIndex=9 elementtype="30">
<A id=anchor2 title="" tabIndex=10 href="" elementtype="30" name="anchor2">Link1</A></DIV></DIV>
<DIV id="Tabs strip1" class="IBIfield IBI_TabfolderStrip" title="" tabIndex=11 elementtype="4" childid="Tab #%d" nexttabnumber="3" persistentuniqueid="compUid_1">
<DIV id=tabitem1 class="IBIfield IBI_tabItem IBI_tabItem-selected" title="" tabIndex=14 elementtype="39" selected="1" tabsreportset="Report set1">Tab #1</DIV>
<DIV id=tabitem2 class="IBIfield IBI_tabItem" title="" tabIndex=30 elementtype="39" tabsreportset="Report set2">Tab #2</DIV></DIV>
<DIV id="Report set1" class="IBIfield IBI_ReportSet" title="" tabIndex=12 elementtype="63">
<DIV id="Report set title1" class="IBIfield IBI_ReportTitle" title="" tabIndex=13 elementtype="4">Report set title</DIV>
<FORM id=form1 class="IBIfield IBI_ReportControlPanel" title="" onsubmit="OnExecute(this);return false;" method=post elementtype="31" fexlist_list="report2" requests_list="1;0" 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" form_type="1" default_slider_type="4" form_newline_chain="1" name="form1">
<TABLE contentEditable=false>
<TBODY>
<TR vAlign=center>
<TD>
<LABEL id=label1 class="IBIfield IBI_ReportControlLabel" tabIndex=26 for=edit1 name="edit1">CAR</LABEL></TD></TR>
<TR vAlign=top>
<TD>
<INPUT style="WIDTH: 198px; HEIGHT: 25px" id=edit1 class="IBIfield IBI_ReportControlTarget" tabIndex=27 value=AUDI hspace=0 persistentuniqueid="compUid_2" defaultlocation="0,0,25,198" boundtovariable="1" requiredfield="1" name="edit1"></TD></TR></TBODY></TABLE>
<TABLE>
<TBODY>
<TR groupChildren="1">
<TD vAlign=center>
<INPUT id=submit1 class="IBIfield IBI_button IBI_btn-run" title="Click to Run" tabIndex=21 value=" " type=submit elementtype="19" name="submit1"></TD>
<TD vAlign=center>
<INPUT id=reset1 class="IBIfield IBI_button IBI_btn-reset" title="Click to Reset" tabIndex=22 value=" " type=reset elementtype="20" name="reset1"></TD></TR></TBODY></TABLE></FORM>
<DIV id="Reports-Charts display1" class="IBIfield IBI_ReportDisplay" title="" tabIndex=23 elementtype="34" rgcontainer="1">
<IFRAME style="WIDTH: 100%; HEIGHT: 350px" id=report2 class="IBIfield IBI_Report-iFrame" tabIndex=25 frameBorder=no elementtype="2" requests_list="0" autoExecute="false" name="report2"></IFRAME></DIV></DIV>
<DIV id="Report set2" class="IBIfield IBI_ReportSetHidden" title="" tabIndex=28 elementtype="63">
<DIV id="Report set title2" class="IBIfield IBI_ReportTitle" title="" tabIndex=29 elementtype="4">Report set title</DIV>
<FORM id=form2 class="IBIfield IBI_ReportControlPanel" title="" onsubmit="OnExecute(this);return false;" method=post elementtype="31" 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" form_type="1" default_slider_type="4" form_newline_chain="1" name="form2">
<INPUT id=submit2 class="IBIfield IBI_button IBI_btn-run" title="Click to Run" tabIndex=37 value=" " type=submit elementtype="19" name="submit2">
<INPUT id=reset2 class="IBIfield IBI_button IBI_btn-reset" title="Click to Reset" tabIndex=38 value=" " type=reset elementtype="20" name="reset2"></FORM>
<DIV id="Reports-Charts display2" class="IBIfield IBI_ReportDisplay" title="" tabIndex=39 elementtype="34" rgcontainer="1">
<IFRAME style="WIDTH: 100%; HEIGHT: 350px" id=report4 class="IBIfield IBI_Report-iFrame" tabIndex=41 frameBorder=no elementtype="2" requests_list="1" autoExecute="false" name="report4"></IFRAME></DIV></DIV></DIV>
<INPUT style="POSITION: absolute; TOP: -100px; LEFT: -100px" id=layoutinfo type=hidden templatetabs="tabitem1;tabitem2" resourcectrlids="ITEM1;IBI_TABBED_CSS;IBI_THEME_CSS">
<INPUT style="POSITION: absolute; TOP: -100px; LEFT: -100px" id=ibiapp_app value=multitab 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="CAR" name="CAR" default="AUDI" textvarname="" accept="0" select="0" create="1">
<link linktype="default" from="compUid_2">
<condition default="1" name="Default" whattodowithcontrol="4" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0">
<data_info checkForDuplicateValues="0" displayfield="CAR" ibiformat="A16" datafield="CAR" datasource="car.mas" datatype="0" selectedvalue="AUDI" operation="" slider_range_from="" slider_range_to="" previewvalue="AUDI" sourcetype="typeMaster">
<static_values>
<static value="AUDI" display="AUDI" selected="1" noinput="0"></static></static_values></data_info></condition></link>
<requestid id="0"></requestid>
<requestid id="1"></requestid></variable>
<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="" previewvalue=" " sourcetype="typeMaster">
<static_values>
<static value=" " display=" " selected="1" noinput="0"></static></static_values></data_info></condition></link>
<requestid id="0"></requestid>
<requestid id="1"></requestid></variable></variables>
<input_controls>
<input_control bindcontrolid="compUid_2" elementtype="7" name="edit1" id="edit1" multiple="0" onetimepopulated="1">
<link linktype="default">
<condition default="1" name="Default" whattodowithcontrol="0" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0">
<data_info checkForDuplicateValues="0" datatype="0" datasource="car.mas" datafield="CAR.COMP.CAR" displayfield="CAR.COMP.CAR" addalloption="0" sourcetype="typeMaster" cacheruntimedata="0" ibiformat="A16" dfformat="A16" accept="0" operation="NONE">
<static_values>
<static value="AUDI" display="AUDI" selected="1" noinput="0"></static></static_values></data_info></condition></link></input_control></input_controls>
<other_bound_objects></other_bound_objects>
<requests nextrequestsid="1">
<request requestid="0" targetname="report2" ibif_ex="report2" targettype="iframe" sourcetype="typeAdhocfex" activereport="0" compoundreport="0" reportcolumns="" reportrealcolumns="" ibiapp_app="">
<![CDATA[-* File report1.fex
-SET &ECHO=ALL;
-DEFAULT &CAR = 'AUDI';
-DEFAULT &COUNTRY = '';
TABLE FILE CAR
PRINT
CAR.COMP.CAR
BY LOWEST CAR.ORIGIN.COUNTRY
-IF &COUNTRY NE '' THEN GOTO FLBL0001;
WHERE CAR.COMP.CAR EQ '&CAR.EVAL';
-GOTO FLBL0002
-FLBL0001
WHERE CAR.ORIGIN.COUNTRY EQ '&COUNTRY.EVAL';
-FLBL0002
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,
$
TYPE=DATA,
COLUMN=N1,
FOCEXEC=report1( \
COUNTRY='&COUNTRY' \
),
$
ENDSTYLE
END
]]></request>
<request requestid="1" targetname="report4" ibif_ex="report4" targettype="iframe" sourcetype="typeAdhocfex" activereport="0" compoundreport="0" reportcolumns="" reportrealcolumns="" ibiapp_app="">
<![CDATA[-* File report2.fex
-SET &ECHO=ALL;
-DEFAULT &CAR = 'AUDI';
-DEFAULT &COUNTRY = '';
TABLE FILE CAR
PRINT
CAR.COMP.CAR
BY LOWEST CAR.ORIGIN.COUNTRY
-IF &COUNTRY NE '' THEN GOTO FLBL0001;
WHERE CAR.COMP.CAR EQ '&CAR.EVAL';
-GOTO FLBL0002
-FLBL0001
WHERE CAR.ORIGIN.COUNTRY EQ '&COUNTRY.EVAL';
-FLBL0002
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,
$
TYPE=DATA,
COLUMN=N1,
FOCEXEC=report2( \
COUNTRY='JAPAN' \
),
$
ENDSTYLE
END
]]></request></requests></rootxmlnode></script>
</xml></BODY>
<SCRIPT id=IBI_loader type=text/javascript>
doBeforeLoad();
</SCRIPT>
</HTML>
<JG> posted July 11, 2011 12:12 PM
The issue is quite straight forward. Once you have run the report the returned frames are independant of each other. For a drilldown in one frame to refresh the other then you must re-run both requests with the required parameters. TYPE=DATA, COLUMN=N1, FOCEXEC=report2( \ COUNTRY='JAPAN' \ ), $ Will not do that. You must call a javascript that runs the drilldowns that can target both frames. That's basically got to be calling two focus requests with the correct parameters and target frames.
Platinum Member JG thanks I will try it tomorrow
Platinum Member JG I have tried to make a javascipt to activate the applications with the correct parameters on the two frames but my javascipt skills are not that good. Is it possible that you can send me a excample?
Please Wait. Your request is being processed...
Read-Only TopicCopyright © 1996-2020 Information Builders