Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Multiple Reports Download
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Multiple Reports Download
 Login/Join
 
Member
posted
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,


7.6.9, Windows
Excel, HTML, PDF, etc.
 
Posts: 5 | Registered: September 20, 2010Reply With QuoteReport This Post
Virtuoso
posted Hide Post
ReportCaster...
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Reply With QuoteReport This Post
Expert
posted Hide Post
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, 2006Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Hey Ginny...glad to see you posting!
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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, 2007Reply With QuoteReport This Post
<JG>
posted
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>,
 
Reply With QuoteReport This Post
Member
posted Hide Post
Thanks a lot for the basic example. Will try that! Smiler


7.6.9, Windows
Excel, HTML, PDF, etc.
 
Posts: 5 | Registered: September 20, 2010Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Multiple Reports Download

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.