Is there a way to have Word as a Display Format? I've looked all over and haven't been able to find how to do this.
Thanks.
June 02, 2005, 03:07 PM
reFOCUSing
Give this a try: TABLE FILE CAR SUM RETAIL_COST DEALER_COST BY CAR ON TABLE PCHOLD FORMAT DOC END -RUN
June 02, 2005, 06:19 PM
<Larry A>
Thanks. That put me in the right direction. I can see that I'll have to do some work on the formatting though.
Thanks again.
June 08, 2005, 12:13 PM
Carol Dobson
Try....
ON TABLE HOLD FORMAT WP
Good Luck! Carol
June 08, 2005, 08:25 PM
Bob Jude Ferrante
The problem with DOC and WP formats in WebFOCUS is you don't get formatting. And WP has that silly NULL as first character - a relic from MVS days.
Here is another technique that actually gets you a FORMATTED document.
In the FOCEXEC, but *before* your TABLE FILE, issue a FILEDEF like this:
APP FILEDEF MYDOC DISK MYAPP\MYDOC.DOC
where MYAPP is a WebFOCUS application folder and MYDOC is your filename.
Then, in your TABLE FILE request, issue a line like this
ON TABLE HOLD AS MYDOC FORMAT HTML
What happens is WebFOCUS outputs an HTML file with a DOC extension. Word can open this just fine (as long as you have Office or Word 97 or later) and all your formatting is preserved.
July 28, 2005, 10:18 PM
Prarie
This works....but does anyone know how to get it to recognize a page-break when it prints?
Thanks..
August 12, 2005, 07:12 PM
Prarie
Does anyone have any ideas on the Page Break issue on doing this.. it prints as one continuous page..
August 12, 2005, 08:32 PM
Leah
Hi, this creates a word document, however, due to the page eject, you get one blank page. The FILEDEF is one of our WebFOCUS directories we use as a mapped drive to get to information we save.
FILEDEF DDD DISK D:\FOCUS\UNO\QUALOUT\TEST.DOC TABLE FILE CAR PRINT MODEL BY COUNTRY ON COUNTRY PAGE-BREAK ON TABLE SAVE AS DDD FORMAT DOC END
August 25, 2005, 09:46 PM
Bob N.
This topic comes close to something I need to accomplish. I need to have a formatted report open up in a browser window using the Word plugin.
The trick holding the output in html format does preserve the formatting, and gets me close, but our users would not have access to the doc file, hence the need to have it open in the browser.
Any ideas?
Thanks
August 26, 2005, 03:30 AM
TexasStingray
Ok, Lets think out side the box. If the WebFOCUS Client and The WebFOCUS Reporting Server are on the save box and If holding it with format HTML give you what you want. Then you can hold/save the file to the directory that is define as the web server alias approot. Then at the bottom of the focexec add the following code.
-HTMLFORM BEGIN
<SCRIPT language="javascript">
<br />var gotopage = "/approot/temp/tempfile.doc";
window.location.replace
(gotopage);
</BODY>-HTMLFORM END
making it look something like this
FILEDEF OUTPUT DISK C:\ibi\apps\temp\tempfile.doc
TABLE FILE CAR<br />PRINT CAR MODEL BODY
BY COUNTRY<br />ON TABLE
HOLD AS OUTPUT FORMAT HTML
-HTMLFORM BEGIN<
<SCRIPT language="javascript">
<br />var gotopage = "/approot/temp/tempfile.doc";
window.location.replace(
gotopage);
-HTMLFORM END<br />-RUN<br />-EXIT
You may have to d o some additional coding to generate a unique hold file so one users file does not get written over by anothersThis message has been edited. Last edited by: <Mabel>,
August 26, 2005, 01:00 PM
Prarie
I save the File as mentioned above and using Reportcaster, have it e-mailed to the user...where they can open it and save it where they want. You can also Filedef the report to a local drive, and just tell the user where it is...but I like the e-mail method.