Question

2
Replies
2078
Views
Diane Jane Tan (DianeT67)
Accenture

Accenture
PH
DianeT67 Member since 2017 5 posts
Accenture
Posted: September 10, 2018
Last activity: September 11, 2018
Posted: 10 Sep 2018 14:35 EDT
Last activity: 11 Sep 2018 3:09 EDT
Closed

How to attach generated excel from Report Definition and send as Correspondence Email in an activity

Hi,

I have a requirement to generate a report definition and export it as an excel file which would be attached to a correspondence email.

For the first requirement, I have used Property-Set > Call pxRetrieveReportData > Call pzRDExportWrapper.

This would extract the RD and export it as excel format, but there is a "save as" dialog box as prompt to the user where to save the file. Since I don't need the file to be saved locally in a desktop, how do I save it as an attachment instead?

Next step is I have used Call SendSimpleEmail and inputted the CorrName. I noticed that there are parameters for Attachment. I would like to know how to connect/integrate the generated excel file from pzRDExportWrapper and pass it to the Email parameters as attachment?

Any help is appreciated. Thank you!

Enterprise Application Development Dev/Designer Studio Data Integration Java and Activities Case Management Reporting
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.