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!
Member posted September 29, 2010 01:16 AM
I am generating multiple reports as per the user request. If the user wants to download all the reports at a time how could I achieve that. All the reports will be in same format.
This message has been edited. Last edited by: Kerry , October 12, 2010 01:46 PM 7.6.9, Windows Excel, HTML, PDF, etc.
Virtuoso ReportCaster...
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005
IP
Expert Or Document Composer to put all the reports into a single file.
Ginny --------------------------------- Prod: WF 7.7.01 Dev: WF 7.6.9-11 Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006
IP
Virtuoso Hey Ginny...glad to see you posting!
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005
IP
Virtuoso In a nutshell, you can't return the output of multiple reports back to a browser or browser helper application. They've either all got to be run into a single compound report as Ginny suggests or as multiple tasks on a single scheduled job in ReportCaster. (or something funky like adding a link to the next report in the heading of the previous report - which still would require running multiple jobs with individual files returned.)
Regards, Darin In FOCUS since 1991 WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex WF Client: 77 on Linux w/Tomcat
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007
IP
<JG> posted October 01, 2010 06:37 AM
Little bit of java script to dynamically populate seperate iframes will do what is required.
These can be tabbed and hidden or shown dependant on howmany reports are called
feeling in a good mood today so here is a basic example
<HTML>
<HEAD>
<META id=mycharsetmeta content="text/html; charset=ISO-8859-1" http-equiv=Content-Type>
<META id=Generation content="Created in release 7701, Generation 3.0">
<SCRIPT id=IBI_RelCallBack type=text/javascript>function AdjustChildrenPosition(){
}
</SCRIPT>
<SCRIPT id=IBI_OptionsScript type=text/javascript>
var cgipath = "cgipath";
var ibirls = "ibirls3";
var rltdyncalendar = "rltdyncalendar";
var gmap = "ibigmap";
var olap="olap";
var olappanebase="olappanebase";
var olapdrill="olapdrill";
var ibixmltree="ibixmltree";
var ibiOptions = new Array(cgipath,ibirls);
</SCRIPT>
<SCRIPT id=IBI_nls type=text/javascript src="/ibi_html/javaassist/nls.js"></SCRIPT>
<SCRIPT id=IBI_nlsVars type=text/javascript src="/ibi_html/javaassist/nlsvars.js"></SCRIPT>
<SCRIPT id=IBI_ibigbl type=text/javascript src="/ibi_html/javaassist/ibi/html/js/ibigbl.js"></SCRIPT>
<SCRIPT id=IBI_ibigblloadCss type=text/javascript>
ibigblloadCss(null);
addIntlTranslatedJS("composertrans.js");
</SCRIPT>
<TITLE>HtmlPage</TITLE>
<SCRIPT id=clientEventHandlersJS type=text/javascript>
//Begin function window_onload
function window_onload() {
UpdateData();
document.getElementById("tabitem1").style.visibility="hidden";
document.getElementById("tabitembody1").style.visibility="hidden";
document.getElementById("iframe1").style.visibility="hidden";
document.getElementById("tabitem2").style.visibility="hidden";
document.getElementById("tabitembody2").style.visibility="hidden";
document.getElementById("iframe2").style.visibility="hidden";
document.getElementById("tabitem3").style.visibility="hidden";
document.getElementById("tabitembody3").style.visibility="hidden";
document.getElementById("iframe3").style.visibility="hidden";
document.getElementById("tabitem4").style.visibility="hidden";
document.getElementById("tabitembody4").style.visibility="hidden";
document.getElementById("iframe4").style.visibility="hidden";
// 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 button1_onclick
function button1_onclick(ctrl) {
if (document.getElementById("radio1_0").checked == true){
document.getElementById("tabitem1").style.visibility="visible";
document.getElementById("tabitembody1").style.visibility="visible";
document.getElementById("iframe1").style.visibility="visible";
var url = "/ibi_apps/WFServlet?IBIF_ex=carinst";
url += "&COUNTRY=ENGLAND";
url += "&_random=" + Math.random();
document.getElementById("iframe1").src=url;
}
else
if (document.getElementById("radio1_0").checked == false){
document.getElementById("tabitem1").style.visibility="hidden";
document.getElementById("tabitembody1").style.visibility="hidden";
document.getElementById("iframe1").style.visibility="hidden";
}
if (document.getElementById("radio1_1").checked == true){
document.getElementById("tabitem2").style.visibility="visible";
document.getElementById("tabitembody2").style.visibility="visible";
document.getElementById("iframe2").style.visibility="visible";
var url = "/ibi_apps/WFServlet?IBIF_ex=carinst";
url += "&COUNTRY=W GERMANY";
url += "&_random=" + Math.random();
document.getElementById("iframe2").src=url;
}
else
if (document.getElementById("radio1_1").checked == false){
document.getElementById("tabitem2").style.visibility="hidden";
document.getElementById("tabitembody2").style.visibility="hidden";
document.getElementById("iframe2").style.visibility="hidden";
}
if (document.getElementById("radio1_2").checked == true){
document.getElementById("tabitem3").style.visibility="visible";
document.getElementById("tabitembody3").style.visibility="visible";
document.getElementById("iframe3").style.visibility="visible";
var url = "/ibi_apps/WFServlet?IBIF_ex=carinst";
url += "&COUNTRY=ITALY";
url += "&_random=" + Math.random();
document.getElementById("iframe3").src=url;
}
else
if (document.getElementById("radio1_2").checked == false){
document.getElementById("tabitem3").style.visibility="hidden";
document.getElementById("tabitembody3").style.visibility="hidden";
document.getElementById("iframe3").style.visibility="hidden";
}
if (document.getElementById("radio1_3").checked == true){
document.getElementById("tabitem4").style.visibility="visible";
document.getElementById("tabitembody4").style.visibility="visible";
document.getElementById("iframe4").style.visibility="visible";
var url = "/ibi_apps/WFServlet?IBIF_ex=carinst";
url += "&COUNTRY=JAPAN";
url += "&_random=" + Math.random();
document.getElementById("iframe4").src=url;
}
else
if (document.getElementById("radio1_3").checked == false){
document.getElementById("tabitem4").style.visibility="hidden";
document.getElementById("tabitembody4").style.visibility="hidden";
document.getElementById("iframe4").style.visibility="hidden";
}
}
//End function button1_onclick
</SCRIPT>
<SCRIPT for=window type=text/javascript eventname="onload">window.onload = function() { window_onload(); }</SCRIPT>
<STYLE id=ibi_defaultstyleElt type=text/css>.tabitemsclass {
BACKGROUND-COLOR: white
}
</STYLE>
</HEAD>
<BODY style="OVERFLOW: auto" nextelementuniquenumber="5" edaconnectionrequired="false" elementtype="21" thumbnailscale="4">
<SPAN style="Z-INDEX: 2; POSITION: absolute; WIDTH: 620px; HEIGHT: 420px; TOP: 130px; LEFT: 80px" id=tab1 tabIndex=2 elementtype="38" tabitemsdefaultdist="5"
tablocation="top" tabitemsdefaultwidth="100" tabitemsdefaultheight="25" tabedgerounded="straight">
<SPAN style="Z-INDEX: 5; BORDER-BOTTOM: white thin; POSITION: absolute; TEXT-ALIGN: center; BORDER-LEFT: teal 1px solid; WRITING-MODE: lr-tb; WIDTH: 100px;
BORDER-COLLAPSE: collapse; BACKGROUND-REPEAT: no-repeat; TABLE-LAYOUT: auto; HEIGHT: 26px; VISIBILITY: hidden; BORDER-TOP: gold 3px solid; TOP: 0px; CURSOR:
pointer; BORDER-RIGHT: teal 1px solid; LEFT: 15px" id=tabitem1 class=tabitemsclass tabIndex=3 elementtype="39" tabbody="tabitembody1"
selectedtab="true">Report 1</SPAN>
<SPAN style="Z-INDEX: 4; BORDER-BOTTOM: teal 1px solid; POSITION: absolute; BORDER-LEFT: teal 1px solid; WIDTH: 620px; DISPLAY: block; HEIGHT: 395px;
VISIBILITY: hidden; BORDER-TOP: teal 1px solid; TOP: 25px; BORDER-RIGHT: teal 1px solid; LEFT: 0px" id=tabitembody1 class=tabitemsclass tabIndex=4
elementtype="40">
<IFRAME style="Z-INDEX: 8; POSITION: absolute; WIDTH: 620px; HEIGHT: 395px; VISIBILITY: hidden; TOP: 30px; LEFT: 0px" id=iframe1 tabIndex=16 src=""
frameBorder=no HEIGHTOLD="395" WIDTHOLD="620" autoExecute="False" name="iframe1"></IFRAME></SPAN>
<SPAN style="Z-INDEX: 3; BORDER-BOTTOM: white thin; POSITION: absolute; TEXT-ALIGN: center; BORDER-LEFT: teal 1px solid; WRITING-MODE: lr-tb; WIDTH: 100px;
HEIGHT: 22px; VISIBILITY: hidden; BORDER-TOP: teal 1px solid; TOP: 3px; CURSOR: pointer; BORDER-RIGHT: teal 1px solid; LEFT: 120px" id=tabitem2
class=tabitemsclass tabIndex=5 elementtype="39" tabbody="tabitembody2" selectedtab="false">Report 2</SPAN>
<SPAN style="Z-INDEX: 2; BORDER-BOTTOM: teal 1px solid; POSITION: absolute; BORDER-LEFT: teal 1px solid; WIDTH: 620px; DISPLAY: none; HEIGHT: 395px;
VISIBILITY: hidden; BORDER-TOP: teal 1px solid; TOP: 25px; BORDER-RIGHT: teal 1px solid; LEFT: 0px" id=tabitembody2 class=tabitemsclass tabIndex=6
elementtype="40">
<IFRAME style="Z-INDEX: 8; POSITION: absolute; WIDTH: 620px; HEIGHT: 395px; VISIBILITY: hidden; TOP: 30px; LEFT: 0px" id=iframe2 tabIndex=16 src=""
frameBorder=no HEIGHTOLD="395" WIDTHOLD="620" autoExecute="False" name="iframe2"></IFRAME></SPAN>
<SPAN style="Z-INDEX: 3; BORDER-BOTTOM: white thin; POSITION: absolute; TEXT-ALIGN: center; BORDER-LEFT: teal 1px solid; WRITING-MODE: lr-tb; WIDTH: 100px;
HEIGHT: 22px; VISIBILITY: hidden; BORDER-TOP: teal 1px solid; TOP: 3px; CURSOR: pointer; BORDER-RIGHT: teal 1px solid; LEFT: 225px" id=tabitem3
class=tabitemsclass tabIndex=9 elementtype="39" tabbody="tabitembody3" selectedtab="false">Report 3</SPAN>
<SPAN style="Z-INDEX: 2; BORDER-BOTTOM: teal 1px solid; POSITION: absolute; BORDER-LEFT: teal 1px solid; WIDTH: 620px; DISPLAY: none; HEIGHT: 395px;
VISIBILITY: hidden; BORDER-TOP: teal 1px solid; TOP: 25px; BORDER-RIGHT: teal 1px solid; LEFT: 0px" id=tabitembody3 class=tabitemsclass tabIndex=10
elementtype="40">
<IFRAME style="Z-INDEX: 8; POSITION: absolute; WIDTH: 620px; HEIGHT: 395px; VISIBILITY: hidden; TOP: 30px; LEFT: 0px" id=iframe3 tabIndex=16 src=""
frameBorder=no HEIGHTOLD="395" WIDTHOLD="620" autoExecute="False" name="iframe3"></IFRAME></SPAN>
<SPAN style="Z-INDEX: 3; BORDER-BOTTOM: white thin; POSITION: absolute; TEXT-ALIGN: center; BORDER-LEFT: teal 1px solid; WRITING-MODE: lr-tb; WIDTH: 100px;
HEIGHT: 22px; VISIBILITY: hidden; BORDER-TOP: teal 1px solid; TOP: 3px; CURSOR: pointer; BORDER-RIGHT: teal 1px solid; LEFT: 330px" id=tabitem4
class=tabitemsclass tabIndex=11 elementtype="39" tabbody="tabitembody4" selectedtab="false">Report 4</SPAN>
<SPAN style="Z-INDEX: 2; BORDER-BOTTOM: teal 1px solid; POSITION: absolute; BORDER-LEFT: teal 1px solid; WIDTH: 620px; DISPLAY: none; HEIGHT: 395px;
VISIBILITY: hidden; BORDER-TOP: teal 1px solid; TOP: 25px; BORDER-RIGHT: teal 1px solid; LEFT: 0px" id=tabitembody4 class=tabitemsclass tabIndex=12
elementtype="40">
<IFRAME style="Z-INDEX: 8; POSITION: absolute; WIDTH: 620px; HEIGHT: 395px; VISIBILITY: hidden; TOP: 30px; LEFT: 0px" id=iframe4 tabIndex=16 src=""
frameBorder=no HEIGHTOLD="395" WIDTHOLD="620" autoExecute="False" name="iframe4"></IFRAME></SPAN> </SPAN>
<SPAN style="Z-INDEX: 9; POSITION: absolute; WIDTH: 360px; HEIGHT: 20px; TOP: 50px; LEFT: 80px" id=text2 tabIndex=17 persistentuniqueid="compUid_2">Select
Reports To Run</SPAN>
<SPAN style="Z-INDEX: 10; POSITION: absolute; OVERFLOW-Y: auto; WIDTH: 360px; HEIGHT: 40px; OVERFLOW: hidden; TOP: 80px; LEFT: 80px" id=checkbox1 tabIndex=18
contentEditable=false elementtype="11" persistentuniqueid="compUid_3" multiple="multiple" groupChildren="1" columns="4" name="checkbox1">
<TABLE style="WIDTH: 100%; HEIGHT: 100%" contentEditable=false cellSpacing=0 cellPadding=0>
<TBODY>
<TR>
<TD noWrap>
<LABEL style="CURSOR: default" id=radio1_LABEL_0 for=radio1_0>
<INPUT id=radio1_0 tabIndex=18 value="Report 1" type=checkbox noinput="0" displaytext="Report 1" name="radio1">Report 1</LABEL></TD>
<TD> </TD>
<TD noWrap>
<LABEL style="CURSOR: default" id=radio1_LABEL_1 for=radio1_1>
<INPUT id=radio1_1 tabIndex=18 value="Report 2" type=checkbox noinput="0" displaytext="Report 2" name="radio1">Report 2</LABEL></TD>
<TD> </TD>
<TD noWrap>
<LABEL style="CURSOR: default" id=radio1_LABEL_2 for=radio1_2>
<INPUT id=radio1_2 tabIndex=18 value="Report 3" type=checkbox noinput="0" displaytext="Report 3" name="radio1">Report 3</LABEL></TD>
<TD> </TD>
<TD noWrap>
<LABEL style="CURSOR: default" id=radio1_LABEL_3 for=radio1_3>
<INPUT id=radio1_3 tabIndex=18 value="Report 4" type=checkbox noinput="0" displaytext="Report 4" name="radio1">Report
4</LABEL></TD></TR></TBODY></TABLE></SPAN>
<INPUT style="Z-INDEX: 11; POSITION: absolute; WIDTH: 150px; HEIGHT: 30px; TOP: 70px; LEFT: 480px" id=button2 language=javascript tabIndex=19
onclick=button1_onclick(this) value="Run Reports" type=button persistentuniqueid="compUid_5" name="button2">
<INPUT style="POSITION: absolute; TOP: -100px; LEFT: -100px" id=layoutinfo type=hidden tabcontrolids="tab1">
<INPUT style="POSITION: absolute; TOP: -100px; LEFT: -100px" id=ibiapp_app value=ibisamp type=hidden name="ibiapp_app">
<INPUT style="POSITION: absolute; TOP: -100px; LEFT: -100px" id=ibic_server value=EDASERVE type=hidden isdataserversarea="1" name="ibic_server">
<xml id=focus_xmlelement>
<script type="text/xml" nextelementuniquenumber="3">
<rootxmlnode focoption="_FOC_NULL" top="50" left="10" width="150" height="130">
<variables></variables>
<input_controls>
<input_control bindcontrolid="compUid_3" elementtype="11" name="checkbox1" id="checkbox1" multiple="1" onetimepopulated="1">
<link linktype="default" persistentuniqueid="compUid_2">
<condition default="1" name="Default" whattodowithcontrol="0" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0">
<data_info checkForDuplicateValues="0" sourcetype="typeMaster">
<static_values>
<static value="Report 1" display="Report 1" selected="0" noinput="0"></static>
<static value="Report 2" display="Report 2" selected="0" noinput="0"></static>
<static value="Report 3" display="Report 3" selected="0" noinput="0"></static>
<static value="Report 4" display="Report 4" selected="0"
noinput="0"></static></static_values></data_info></condition></link></input_control></input_controls>
<other_bound_objects></other_bound_objects>
<requests></requests></rootxmlnode></script>
</xml></BODY>
<SCRIPT id=IBI_loader type=text/javascript>
doBeforeLoad();
</SCRIPT>
</HTML>
This message has been edited. Last edited by: <JG>, October 01, 2010 08:34 AM
Member Thanks a lot for the basic example. Will try that!
7.6.9, Windows Excel, HTML, PDF, etc.
Please Wait. Your request is being processed...
Read-Only TopicCopyright © 1996-2020 Information Builders