Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Go
New
Search
Notify
Tools
Reply
  
Email WebFocus report
 Login/Join
 
Member
posted
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
 
Posts: 3 | Registered: September 08, 2009Reply With QuoteReport This Post
Silver Member
posted Hide Post
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
 
Posts: 38 | Location: Austria, Linz | Registered: June 19, 2009Reply With QuoteReport This Post
  Powered by Social Strata  
 


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