Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at myibi@ibi.com and provide your corporate email address, company, and name.


Connect to myibi

Read-Only Read-Only Topic
Go
Search
Notify
Tools
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, 2009Report 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, 2009Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic


Copyright © 1996-2020 Information Builders