D365FO Send Report as email attachment
Hi All ,
Usually in any implementation project we get request to send Report as a attachment in email. Below is code going to help you to send report as an email attachment. In the below code I am saving report in report archive(DocuRef table ) reading it from DocuRef table in to bytes and converting it in to memory stream. The memory stream is further I am going to use to send an email with Subject and body using SysMailerMessageBuilder class. You can use following methods of this class
setSubject - To set Subject of the email.
setBody - To Set email body .
setFrom - To set sender of the email.
sendInteractive - To send interactively.
sendNonInteractive - TO send non interactively
Usually in any implementation project we get request to send Report as a attachment in email. Below is code going to help you to send report as an email attachment. In the below code I am saving report in report archive(DocuRef table ) reading it from DocuRef table in to bytes and converting it in to memory stream. The memory stream is further I am going to use to send an email with Subject and body using SysMailerMessageBuilder class. You can use following methods of this class
setSubject - To set Subject of the email.
setBody - To Set email body .
setFrom - To set sender of the email.
sendInteractive - To send interactively.
sendNonInteractive - TO send non interactively
Args args; SalesInvoiceContract salesInvoiceContract; CustInvoiceJour custInvoiceJourLocal; SRSPrintDestinationSettings SRSPrintDestinationSettings; #SRSFramework body = "Hello" //HTML BOdy args = new Args(); select firstOnly custInvoiceJourLocal where custInvoiceJourLocal.InvoiceId == caaTrustFollowUpInvoices.InvoiceId; args.record(custInvoiceJourLocal); SrsReportRunController salesInvoiceController = new SrsReportRunController(); salesInvoiceController.parmArgs(args); salesInvoiceController.parmReportName(PrintMgmtDocType::construct(PrintMgmtDocumentType::SalesOrderInvoice).getDefaultReportFormat()); salesInvoiceController.parmShowDialog(false); salesInvoiceController.parmLoadFromSysLastValue(false); salesInvoiceContract = salesInvoiceController.parmReportContract().parmRdpContract(); salesInvoiceContract.parmRecordId(custInvoiceJourLocal.RecId); // Record id must be passed otherwise the report will be empty SrsReportDataContract srsReportDataContract = salesInvoiceController.parmReportContract(); //srsReportDataContract.parmisMemoryStreamOnly(true); salesInvoiceController.parmReportContract(srsReportDataContract); SRSPrintDestinationSettings = new SRSPrintDestinationSettings(); SRSPrintDestinationSettings.overridePrintContractSettings(true); SRSPrintDestinationSettings.printMediumType(SRSPrintMediumType::Archive); SRSPrintDestinationSettings.parmOverwriteFileIsSet(true); SRSPrintDestinationSettings.fileFormat(SRSReportFileFormat::PDF); SRSPrintArchiveContract SRSPrintArchiveContract = new SRSPrintArchiveContract(SRSReportFileFormat::PDF); SRSPrintDestinationSettings.parmSRSPrintArchiveContract(SRSPrintArchiveContract); str archiveName = strFmt('%1-%2', curUserId(), timeNow()); salesInvoiceController.parmReportContract().parmReportCaption(archiveName);//**This is the 'Description' field in the archive salesInvoiceController.parmReportContract().parmPrintSettings(SRSPrintDestinationSettings); salesInvoiceController.run(); PrintJobHeader printJobHeader; select firstonly forupdate printJobHeader where printJobHeader.jobDescription == archiveName; DocuRef docuRef; select firstonly forupdate docuRef where docuRef.RefRecId == PrintJobHeader.RecId && docuRef.RefTableId == tableNum(PrintJobHeader) && docuRef.TypeId == #SRSArchiveDocument; DocuValue docuValue; select firstonly forupdate docuValue where docuValue.RecId == docuRef.ValueRecId; container reportBytes = docuValue.File; System.Byte[] binData; System.IO.Stream stream; // Turn the Bytes into a stream for(int i = 0; i < conLen(reportBytes); i++) { binData = conPeek(reportBytes,i+1); stream = new System.IO.MemoryStream(binData); } ttsbegin; printJobHeader.delete(); docuRef.delete(); docuValue.delete(); ttscommit; infolog.clear();//Clear the message about archiving the report var messageBuilder = new SysMailerMessageBuilder(); messageBuilder.addTo(sendToEmail) .setSubject(Subject) .setBody(Body) .addCC(HcmWorker::find(ccEmail).email()); if (sendFromEmail) { messageBuilder.setFrom(sendFromEmail); } if (stream != null) { messageBuilder.addAttachment( stream, 'Invoice.pdf'); } SysMailerFactory::sendNonInteractive(messageBuilder.getMessage());
Comments
Post a Comment