Focal Point
Email WebFocus report

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

September 15, 2010, 08:20 AM
hgouin
Email WebFocus report
Hi,

We are trying to create an iWay process that is using a BI object. The report generate an Excel file and we want to email that report as an attachment with an Email object.

How can I obtain the report result and attach it to an email? The only thing I'm able to get so far is the XML output of the BI box.


WebFOCUS 7.6.9
iWay 5.5, 6.0
iSeries
All formats
September 20, 2010, 04:49 AM
Computix
Hi,

why not just use filedef and hold the report as a file?

FILEDEF REPORT DISK c:\tmp\report.xls

TABLE FILE CAR
PRINT *
ON TABLE HOLD AS REPORT FORMAT EXL2K
END

Then you can use any commandline-tool in order to send the mail and include the attachment.

regards,
computix


WF 7.6.6 (MRE,BID, DevStudio, partly RC) on Windows 2003 /Apache/Tomcat
Output: HTML,Excel,PDF,PPT
Adapters: SQL Server, DB2, Oracle