Send email with report attached as PDF with x++ in D365FO

(3) Share

Report

Posted on by CU09091357-0

598

I’m sending an SSRS report by email from X++ using SrsReportRunController. The email sends fine and the attachment is created, but it always arrives as CSV even though I explicitly set the format to PDF.

SrsReportRunController controller = new SrsReportRunController();
controller.parmReportName(ssrsReportStr(BackStockReport, Report));
controller.parmShowDialog(false);
controller.parmLoadFromSysLastValue(false);

SRSPrintDestinationSettings settings = controller.parmReportContract().parmPrintSettings();
settings.printMediumType(SRSPrintMediumType::Email); // I've tried also File here
settings.fileFormat(SRSReportFileFormat::PDF); // Here
settings.fileName("Report attached");

I’ve already tried disabling dialogs and adjusting print destination settings, but nothing changes the output format.

Categories:

Microsoft Dynamics AX

Dynamics 365 Project Operations

Dynamics 365 Finance

I have the same question (0)

All responses (2)

Answers (1)

Martin Dráb 239,040 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

I think that the file format gets changed later by some other code. The debugger should tell you more.

Or are you able to give us full code demonstrating the problem on a standard report, so we can test your code?

Was this reply helpful? Yes No
Verified answer

Komi Siabi 13,208 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hello,

You need to explicitly define the attachment file format in your SrsReportEMailDataContract.

SrsReportEMailDataContract emailContract; emailContract = new SrsReportEMailDataContract(); emailContract.parmAttachmentFileFormat(SRSReportFileFormat::PDF);

1 people found this reply helpful.

Was this reply helpful? Yes No