 |
|||||
|
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
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. | |||||
Focal Point 
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [CASE] Customize 'WebFOCUS Report' Page Created With 'ON TABLE PCHOLD FORMAT EXL2K'
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [CASE] Customize 'WebFOCUS Report' Page Created With 'ON TABLE PCHOLD FORMAT EXL2K' Read-Only TopicGo | Search | Notify | Tools |
| [CASE] Customize 'WebFOCUS Report' Page Created With 'ON TABLE PCHOLD FORMAT EXL2K' | Login/Join |
| Master |
With the 'ON TABLE PCHOLD FORMAT EXL2K' TABLE command, WebFOCUS creates a 'WebFOCUS Report' page. The code behind the page looks like this: <HTML>
<Head>
<Title>WebFOCUS Report</Title>
<Script type="text/javascript" Language="JavaScript">
<!--
function getrep()
{
if(parseInt(window.navigator.appVersion,10)<4)
location.assign("/ibi_apps/WFServlet?PG_REQTYPE=REDIRECT&PG_MRsaved=false&PG_Func=GETBINARY&PG_File=wvedysyh.xmh");
else
location.replace("/ibi_apps/WFServlet?PG_REQTYPE=REDIRECT&PG_MRsaved=false&PG_Func=GETBINARY&PG_File=wvedysyh.xmh");
} //-->
</Script></Head>
<body onload="getrep()"></BODY>
</HTML><!--
0 NUMBER OF RECORDS IN TABLE= 1000 LINES= 1000
-->The page that the user sees is 'blank'. Is it possible to customize this page, with a friendly message? For example: 'Check your Excel application for your xyz report and close this window.'This message has been edited. Last edited by: Kerry,
| |||
|
| Expert |
You can use &LINES to check to see if there are any records in the report, then branch to a report that shows the message. Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Expert |
Waz, David would like something on that blank window when there IS data to display in Excel. 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 | |||
|
| Master |
Thank you for the clarification, Francis. You are correct. It is 'as if' I wanted to put 'Check your Excel application for...close this window', within the body tags of the page.
| ||||
|
| Expert |
Oops, thats what happens after a long weekend, and not much sleep. Sorry. Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Expert |
- Is that a newly found Territory? 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 | |||
|
| Expert |
 Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Master |
If I can't write a 'user friendly' message to the automatic 'WebFOCUS Report' page, can I suppress its creation? I've done a FocalPoint search, and found threads discussing this matter, but no thread that said definitively that suppression was or was not possible.
| ||||
|
| Master |
here's what we do. -SET &PGMNAME = 'some_name_here'; -* Include before the final hold -*********************************** -SET &APPFILE = &PGMNAME||'.XLS'; APP FILEDEF &PGMNAME DISK LIBRARY/&APPFILE -*********************************** TABLE FILE CAR PRINT * ON TABLE HOLD AS &PGMNAME FORMAT EXL2K END -SET &FILENAME = LOCASE(10,&PGMNAME,&PGMNAME); -SET &LINK = 'http://server:8080/approot/library/'||&FILENAME||'.xls'; -HTMLFORM BEGIN <html> <head> <meta HTTP-EQUIV="REFRESH" content="0; url=&LINK"/> </head> <body> !IBI.FIL.REPORT; </body> </html> ------------------------------------ WF Environment: ------------------------------------ Server/Client, ReportCaster, Dev Studio: 7.6.11 Resource Analyzer, Resource Governor, Library, Maintain, InfoAssist OS: Windows Server 2003 Application/Web Server: Tomcat 5.5.25 Java: JDK 1.6.0_03 Authentication: LDAP, MRREALM Driver Output: PDF, EXL2K, HTM ------------------------------------ Databases: ------------------------------------ Oracle 10g DB2 (AS/400) MSSQL Server 2005 Access/FoxPro | |||
|
| Virtuoso |
Nice! How do you avoid clashing with other sessions that may be running the same report concurrently? A sequential ID of some sort? Prod/Dev: WF Server 8008/Win 2008 - WF Client 8008/Win 2008 - Dev. Studio: 8008/Windows 7 - DBMS: Oracle 11g Rel 2 Test: Dev. Studio 8008 /Windows 7 (Local) Output:HTML, EXL2K. | |||
|
| Master |
Thread update:
| |||
|
| Master |
Thread Update: IB continues to work on the case. (I am guessing they are very busy, in that this case is taking so long.) They have determined, per the case, that the Redirection Settings cannot suppress the rogue 'WebFOCUS Report' under Windows 7. They feel that this is a Microsoft issue and site Article ID: 927009: http://support.microsoft.com/kb/927009 I have asked for a workaround, and they are working on this. | |||
|
| Master |
Thread Update: IB's HelpDesk assisted me with a HTML workaround, for suppressing the 'WebFOCUS Report' redirect window. The 'submit form', on the report launch page now has an iframe. For an Excel report request, this iframe becomes the target of the form, and replaces the blank browser window. Model/example follows: launch.fex -*
-* Set up environment.
-*
-DEFAULTH &IBIMR_domain='MR Domain Name Not Available'
-TYPE Current MR Domain Name is: &IBIMR_domain
-SET &DOMAIN_NAME = &IBIMR_domain;
-SET &FOLDER_NAME = '#test';
-* Create a random number.
-SET &RANDOM = RDUNIF(D5) * RDUNIF(D5) * 10000;
-*
-* Present launch page to user.
-*
-HTMLFORM BEGIN
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head>
<title> GG Sales Report </title>
<meta http-equiv="CACHE-CONTROL" content="NO-CACHE">
-*
-* JavaScript source/code begins here:
-*
<script language=javascript>
//
// Initialize window properties global variable.
//
var WProps = new String("location=no,toolbar=no,directories=no");
WProps += ",scrollbars=yes,menubar=no";
WProps += ",status=no,resizable=yes,top=20,left=10,width=";
WProps += screen.availWidth - 50;
WProps += ",height=";
WProps += screen.availHeight - 80;
//
// Function: sub_form
// Purpose : Call WebFOCUS, to run report.
//
function sub_form() {
// Pull selected Output.
var myindex = document.Form1.selST.selectedIndex;
var myvalue = document.Form1.selST.options[myindex].value;
document.hiddenRunForm.ST.value = myvalue;
// Pull selected Output.
var myindex = document.Form1.selFMT.selectedIndex;
var myvalue = document.Form1.selFMT.options[myindex].value;
document.hiddenRunForm.FMT.value = myvalue;
if (document.hiddenRunForm.FMT.value == 'EXL2K') {
document.hiddenRunForm.target = "ifrmExcel";
} else {
document.hiddenRunForm.target = "report_launch";
// Open the pop up window with a blank page.
rptWindow = window.open("", document.hiddenRunForm.target, WProps);
// Place 'waiting' message in the new window.
var content = new String();
content = '<FONT face="Calibri" size="+1" color="black">';
content += "Your report will be ready shortly. <br>";
content += "Just a moment, please..";
content += "</FONT>";
content += " ";
rptWindow.document.open();
rptWindow.document.write(content);
rptWindow.document.close();
}
// Run the WF report.
document.hiddenRunForm.submit();
}
</script>
</head>
-*
-* Body of Launch Page.
-*
<body>
<form name=Form1 id=Form1>
Select State:
<select name="selST">
<option value="TX">Texas</option>
<option value="IL">Illinois</option>
</select>
<br><br>
Select Format:
<select name="selFMT">
<option value="AHTML">Active</option>
<option value="EXL2K">Excel 2000</option>
<option value="HTMTABLE">Web Page</option>
</select>
<br><br>
-*
-* Control Buttons.
-*
<input value="Run Report" type="button" onClick="sub_form();" />
</form>
-*
-* Hidden Form, submitted to WebFOCUS to run report.
-*
<form name="hiddenRunForm" id="hiddenRunForm" style="visibility:hidden;"
action="/ibi_apps/WFServlet"
method="post" target="">
-*
-* Variables passed from web page to WebFOCUS servlet.
-* -WebFOCUS related variables.
-*
<input type="hidden" name="IBIMR_domain" value="!IBI.AMP.DOMAIN_NAME;">
<input type="hidden" name="IBIMR_action" value="MR_RUN_FEX">
<input type="hidden" name="IBIMR_sub_action" value="MR_STD_REPORT">
<input type="hidden" name="IBIMR_fex" value="app/report.fex">
<input type="hidden" name="IBIF_fex" value="app/report.fex">
<input type="hidden" name="IBIMR_folder" value="!IBI.AMP.FOLDER_NAME;">
<input type="hidden" name="IBIMR_random" value="!IBI.AMP.RANDOM;">
<input type="hidden" name="IBIMR_flags" value="">
<input type="hidden" name="IBIMR_drill" value="RUNNID">
-*
-* Variables passed from web page to WebFOCUS servlet.
-* -Report related variables.
-*
<input type="hidden" name="FMT">
<input type="hidden" name="ST">
-*
<iframe style="POSITION: absolute; DISPLAY: none;"
id=iframe1 tabIndex=2
autoExecute="False"
name="ifrmExcel">
</iframe>
</form>
</body>
</html>
-HTMLFORM ENDreport.fex APP PREPENDPATH IBISAMP -DEFAULTH &ST = 'TX' -SET &HOLD_TYPE = IF &FMT EQ 'EXL2K' THEN 'PCHOLD' ELSE 'HOLD'; TABLE FILE GGSALES PRINT * IF ST EQ &ST ON TABLE &HOLD_TYPE FORMAT &FMT END -RUN -HTMLFORM BEGIN <html> <head> <title>Sales Report</title> </head> <body> !IBI.FIL.HOLD; </form> </body> </html> -HTMLFORM END -EXIT | |||
|
| Expert |
Interesting. How would this work for a HTML Composer generated launch page, how do you change the target based on the output format on the fly? Using JavaScript? Thanks for sharing this. 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 | |||
|
| Master |
Correct, target changed on the fly using JavaScript: if (document.hiddenRunForm.FMT.value == 'EXL2K') {
document.hiddenRunForm.target = "ifrmExcel";
} else {
document.hiddenRunForm.target = "report_launch";
... | |||
|
| Expert |
I wonder what one can do if the HTML page is formless, with this code instead of a form action target: <request requestid="12" sourcetype="typeFex" targettype="window" targetname="wf_report" ibif_ex="app/summary1.fex" IBIMR_domain="mrdom001/mrdom001.htm" IBIMR_folder="#fundproducti" IBIMR_sub_action="MR_STD_REPORT" activereport="0" reportcolumns="..." reportrealcolumns="..." ibiapp_app=""></request> 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 | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicFocal Point Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [CASE] Customize 'WebFOCUS Report' Page Created With 'ON TABLE PCHOLD FORMAT EXL2K'
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [CASE] Customize 'WebFOCUS Report' Page Created With 'ON TABLE PCHOLD FORMAT EXL2K'Copyright © 1996-2020 Information Builders
| View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |