Focal Point
[CLOSED] Multiple Reports Download

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/630106635

September 29, 2010, 01:16 AM
Poorna
[CLOSED] Multiple Reports Download
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.
September 29, 2010, 09:29 AM
Prarie
ReportCaster...
September 29, 2010, 10:20 AM
GinnyJakes
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
September 29, 2010, 10:26 AM
Prarie
Hey Ginny...glad to see you posting!
September 29, 2010, 01:29 PM
Darin Lee
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
October 01, 2010, 06:37 AM
<JG>
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, 09:47 AM
Poorna
Thanks a lot for the basic example. Will try that! Smiler


7.6.9, Windows
Excel, HTML, PDF, etc.