Dynamics Community Forum Thread Details

Send SSRS report as an email attachment using SysEmailTable

Hello all,
I want to send SSRS report using SysEmailTable::send method as an email attachment

SrsReportRunController controller = new SrsReportRunController();
MyEmailContract rdpContract = new MyEmailContract();
SRSPrintDestinationSettings settings;

controller.parmReportName(ssrsReportStr(MyEmailReport, Report));
controller.parmExecutionMode(SysOperationExecutionMode::Synchronous);
controller.parmShowDialog(false);

controller.parmReportContract().parmRdpContract(rdpContract);

settings = controller.parmReportContract().parmPrintSettings();
settings.printMediumType(SRSPrintMediumType::File);
settings.fileFormat(SRSReportFileFormat::PDF);
settings.fileName('Test.pdf');

// Execute the report
controller.startOperation();
str path = controller.parmReportContract().parmReportPath();
SysEmailTable::sendMail("TableBody", "en-us", "Test@Test.com", templateToken, "Test.pdf");

Unfortunately the attachment is not attached and the email is empty :(

Categories:

Dynamics 365 Finance

Microsoft Dynamics AX

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL