September 15, 2010, 08:20 AM
hgouinEmail 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.
September 20, 2010, 04:49 AM
ComputixHi,
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