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     How to Embed a Report in an HTML Web Page
Go
New
Search
Notify
Tools
Reply
  
How to Embed a Report in an HTML Web Page
 Login/Join
 
Guru
posted
Hi,

I create a report "report1"and wanted to embeded it into an HTML Web Page output.htm.
the report is located in:ibisam/procedures
and the html file is : ibisamp/HTML FILES

When I Launch the HTML web page i have the following error:

(FOC36225) UNABLE TO OPEN FILE REPMAJ SPECIFIED BY WEBFOCUS TABLE

The source of the "output.htm" is :

FOCUS Report

<script language='javascript'>
var ibiOptions = new Array("multidrill");
var focexurl = "/ibi_apps/WFServlet?IBIF_webapp=/ibi_apps&IBIC_server=EDASERVE&IBIAPP_app=IBISAMP&";
var fochtmlurl = "/ibi_html";


<script language='javascript' src='/ibi_html/javaassist/nls/js'>
<script language='javascript'src='/ibi_html/javaassist/ibi/html/js/ibigbl.js'>
<script language='javascript'>ibigblloadCss(null);

!IBI.FIL.REPMAJ;

and the source of my report is :

TABLE FILE SHORT
SUM
PROJECTED_RETURN
BY CONTINENT
HEADING
""
FOOTING
""
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE HOLD AS REPMAJ FORMAT HTMTABLE
ON TABLE SET HTMLCSS ON
END
-HTMLFORM output.htm

I am not able to figure out what is wrong.

Regards.


WebFocus 7.6.5
AND WebLogic server as web server
sql2005 as database server
 
Posts: 273 | Location: Europe | Registered: May 31, 2007Reply With QuoteReport This Post
<JG>
posted
Looks very much to me as if your report is not returning any data.
The effect of that is the required hold file is not created.

add 'SET EMPTYREPORT ON' to the code
 
Reply With QuoteReport This Post
Guru
posted Hide Post
Hi JG,

To verify that I just commented the following lines in my report and I could see that it returns data.

-*ON TABLE HOLD AS REPMAJ FORMAT HTMTABLE
END
-*-HTMLFORM output.htm

Regards.


WebFocus 7.6.5
AND WebLogic server as web server
sql2005 as database server
 
Posts: 273 | Location: Europe | Registered: May 31, 2007Reply With QuoteReport This Post
<JG>
posted
Majid,

in that case it could be as simple as not having a -RUN after the END statement.
Although this does not make a difference in 764 it might in some releases.

However, Question, are you redirecting EDATEMP or APP HOLD? if you are then the file
will be in the wrong place and you will either have to allocate the file directly using
FILEDEF or use APP MAP to include the folder in the APP PATH.

Also try coding it as

-HTMLFORM BEGIN
!IBI.FIL.output;
-HTMLFORM END

to see if that resolves the issue.
 
Reply With QuoteReport This Post
Guru
posted Hide Post
Hi JG,

Here is what I did:

TABLE FILE SHORT
SUM
PROJECTED_RETURN
BY CONTINENT
HEADING
""
FOOTING
""
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE HOLD AS REPMAJ FORMAT HTMTABLE
ON TABLE SET HTMLCSS ON
END
-*-HTMLFORM output.htm
-HTMLFORM BEGIN
!IBI.FIL.output;
-HTMLFORM END

And I got the following error:

0 NUMBER OF RECORDS IN TABLE= 526 LINES= 30 HTML FILE SAVED ...(FOC36225) UNABLE TO OPEN FILE output SPECIFIED BY WEBFOCUS TABLEWebFOCUS Version 7.6.2 compiled and linked on Tue Aug 28 11:57:30 EDT 2007 (Gen branch762_hotfix:9)

It seems that the file was generated but the HTML file is not able to open/find it

Thanks.

Majid.


WebFocus 7.6.5
AND WebLogic server as web server
sql2005 as database server
 
Posts: 273 | Location: Europe | Registered: May 31, 2007Reply With QuoteReport This Post
<JG>
posted
Majid,

Add
? PATH
? FILEDEF
-EXIT

Just before the TABLE FILE SHORT

This will allow us to see the mappings and where the file is being saved to
 
Reply With QuoteReport This Post
Expert
posted Hide Post
quote:

ON TABLE HOLD AS REPMAJ FORMAT HTMTABLE
ON TABLE SET HTMLCSS ON
END
-*-HTMLFORM output.htm
-HTMLFORM BEGIN
!IBI.FIL.output;
-HTMLFORM END


It's

!IBI.FIL.REPMAJ;

not

!IBI.FIL.output;


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
 
Posts: 1969 | Location: Centennial, CO | Registered: January 31, 2006Reply With QuoteReport This Post
<JG>
posted
No Tom,

Majid has it correct.

output.htm is a static htm page that has REPMAJ.htm embeded in it
 
Reply With QuoteReport This Post
Expert
posted Hide Post
My Bad!!

Smiler


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
 
Posts: 1969 | Location: Centennial, CO | Registered: January 31, 2006Reply With QuoteReport This Post
Guru
posted Hide Post
Hi All,

Here is the output I got:

BASEAPP = D:\ibi\apps\baseapp;
APPHOLD = D:\ibi\srv76\wfs\edatemp\ts000027;
APPPATH = D:\ibi\apps\ibisamp;
D:\ibi\apps\treasuryforecast;
D:\ibi\apps\cfclive;
D:\ibi\apps\holdfiles;
D:\ibi\apps\cis;
D:\ibi\apps\majid;
D:\ibi\apps\r8test;
D:\ibi\apps\r7_ws_test_cfc;
D:\ibi\apps\r8doc_uni;
D:\ibi\apps\sunssc;
D:\ibi\apps\sunssc;
D:\ibi\apps\necho;
D:\ibi\apps\lux2_live;
D:\ibi\apps\cis;
D:\ibi\apps\cfcviews;
D:\ibi\apps\documents_ge;
D:\ibi\apps\cfcviews;
D:\ibi\apps\ibisamp;
Lname Device Lrecl Recfm Append Filename
============================================================

Regards.


WebFocus 7.6.5
AND WebLogic server as web server
sql2005 as database server
 
Posts: 273 | Location: Europe | Registered: May 31, 2007Reply With QuoteReport This Post
<JG>
posted
Majid, sorry I should have said after the END for the TABLE FILE SHORT.

That way we can see the attributes for the file being generated.

However having said that APPHOLD is pointing to the standard tscom3
work directory for the session so the output file should be OK.

Do not foreget the -RUN after the END statement
 
Reply With QuoteReport This Post
Guru
posted Hide Post
Hi JG,

Here is it:

0 NUMBER OF RECORDS IN TABLE= 526 LINES= 3
0 HTML FILE SAVED ...
(FOC1517) UNRECOGNIZED COMMAND ?PATH
Lname Device Lrecl Recfm Append Filename
============================================================
REPMAJ DISK 0 V D:\ibi\srv76\wfs\edatemp\ts000
028\repmaj.htm

At this time I am trying to go through the webfocus documentation and I find it hard some time to use the eaxmples.

Thanks.


WebFocus 7.6.5
AND WebLogic server as web server
sql2005 as database server
 
Posts: 273 | Location: Europe | Registered: May 31, 2007Reply With QuoteReport This Post
Gold member
posted Hide Post
Hi ran below code from ibisamp dir and my output.html is in ibisamp directory,
and it's working fine, if ibisamp in the app path they should work..

check is there any type eror is there.

TABLE FILE CAR
PRINT
CAR
COUNTRY
BY CAR NOPRINT
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE HOLD AS REPMAJ FORMAT HTMTABLE
ON TABLE SET HTMLCSS ON
END
-RUN
-HTMLFORM output.htm




Env Prod:WebFOCUS 7702 ,Windows xp on 64, SQL Server 2008, IRF Tool
Env 1 Local: DevStudio 7702 - MS Windows XP SP2 - Apache Tomcat 5.0.28
Output: HTML, Excel and PDF
 
Posts: 52 | Location: NJ,USA | Registered: May 26, 2004Reply With QuoteReport This Post
Guru
posted Hide Post
Hi wf1998,

Thanks for you help.
Unfortunatelly it still did not work. Your report is correct if I ouput to the screen.
As you can see from my previous post the ibisam is in the apppath.

Regards.


WebFocus 7.6.5
AND WebLogic server as web server
sql2005 as database server
 
Posts: 273 | Location: Europe | Registered: May 31, 2007Reply With QuoteReport This Post
<JG>
posted
The ? FILEDEF gives a possible clue.

? Weblogic ?

Case sensitivity is a possibility.

Try !IBI.FIL.repmaj; instead of !IBI.FIL.REPMAJ; in output.htm.
 
Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     How to Embed a Report in an HTML Web Page

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