Send SSRS report as an email attachment using SysEmailTable

(2) Share

Report

Posted on by MS-29011540-0

372

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

I have the same question (0)

All responses (6)

Answers (1)

Abhinandhan P S 17 on at

Like (1)

Report
Copy link

Link copied!

Hi,

You can refer the below-mentioned forms.

https://community.dynamics.com/forums/thread/details/?threadid=22ea0895-affd-f011-8406-7c1e521ae427

There was a verified answer. So, can you give it a try?

Thanks,

Abhinandhan Poorlin Sivakumar.

Was this reply helpful? Yes No
Suggested answer

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

Like (1)

Report
Copy link

Link copied!

You get a path, but then you ignore it and use "Test.pdf" instead when calling sendMail(). You seem to intend to use the path variable instead.

If you debug sendMail(), you'll see that the system tries to find a file based on your path, and because no Test.pdf exists, it doesn't add any attachment. You should get used to using the debugger - as you see, just writing some code and checking the final result doesn't tell you what and where failed, but debugging can give you that.

Was this reply helpful? Yes No
Anton Venter 20,656 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@MS-29011540-0

Does your code result in a PDF file and does it exist? The sendMail function will try to attach the file if it exists. Have you used the debugger to see what's going on? If your email body is empty, you should use an existing an email template. Is "TableBody" an email template?

Was this reply helpful? Yes No
MS-29011540-0 372 on at

Like (2)

Report
Copy link

Link copied!

@Abhinandhan P S
Thank you for your reply :)
I tried it but the PDF was downloaded on my computer (as the system user not on the server itself), but i needed it to be downloaded on the server itself because i would like to use it again to send an email using the file as an attachment. maybe i also missed something. i don't know :)

Was this reply helpful? Yes No
MS-29011540-0 372 on at

Like (0)

Report
Copy link

Link copied!

@Anton Venter @Martin Dráb
Thank you for sharing, i actually got benefits when debugging and exploring the sendMail method.

Was this reply helpful? Yes No
Verified answer

MS-29011540-0 372 on at

Like (1)

Report
Copy link

Link copied!

I use something like that and i worked with me
This article helped me:
https://www.d365finopscodebase.com/2020/01/how-to-dynamically-save-pdf-generated.html

public static void main(Args _args)
{

#define.Note('Note')

str url;
SrsReportRunController controller = new SrsReportRunController();
PayrollContract rdpContract = new PayrollContract();
SRSPrintDestinationSettings srsPrintDestinationSettings;
SysCorpNetPrinters netPrinters;
Filename _filename;
System.Byte[] reportBytes = new System.Byte[0]();
SRSProxy srsProxy;
SRSReportRunService srsReportRunService = new SrsReportRunService();
SRSReportExecutionInfo executionInfo = new SRSReportExecutionInfo();
Microsoft.Dynamics.AX.Framework.Reporting.Shared.ReportingService.ParameterValue[] parameterValueArray;
Map reportParametersMap;
str Note = "Purchase order list report";

List li = new List(Types::String);
li.addEnd("ITCO-00001");
rdpContract.parmRunIDList(li);

Map templateToken = new Map(Types::String, Types::String);
templateToken.insert(#Note, Note);

str tempPath = SysEmailParameters::find().AttachmentsPath;
tempPath = strFmt("%1\\%2", tempPath, "Pending purchase orders");

if (!WinAPI::pathExists(tempPath))
{
WinAPI::createDirectoryPath(tempPath);
}

_filename = strFmt("%1\\Pending purchase orders.pdf", tempPath);
controller.parmReportName(ssrsReportStr(PayrollReport, Report));
controller.parmExecutionMode(SysOperationExecutionMode::Synchronous);
controller.parmShowDialog(false);
controller.parmReportContract().parmRdpContract(rdpContract);

srsPrintDestinationSettings = controller.parmReportContract().parmPrintSettings();
srsPrintDestinationSettings.printMediumType(SRSPrintMediumType::File);
srsPrintDestinationSettings.fileFormat(SRSReportFileFormat::PDF);
srsPrintDestinationSettings.overwriteFile(true);
srsPrintDestinationSettings.fileName(_filename);
srsPrintDestinationSettings.pack();

controller.parmReportContract().parmReportServerConfig(SRSConfiguration::getDefaultServerConfiguration());
controller.parmReportContract().parmReportExecutionInfo(executionInfo);
srsReportRunService.getReportDataContract(controller.parmreportcontract().parmReportName());
srsReportRunService.preRunReport(controller.parmreportcontract());
reportParametersMap = srsReportRunService.createParamMapFromContract(controller.parmReportContract());
parameterValueArray = SrsReportRunUtil::getParameterValueArray(reportParametersMap);
srsProxy = SRSProxy::constructWithConfiguration(controller.parmReportContract().parmReportServerConfig());
// Actual rendering to byte array
reportBytes = srsproxy.renderReportToByteArray(controller.parmreportcontract().parmreportpath(), parameterValueArray,srsPrintDestinationSettings.fileFormat(SRSReportFileFormat::PDF), srsPrintDestinationSettings.deviceinfo());

if (reportBytes)
{
System.IO.Stream stream = new System.IO.MemoryStream(reportBytes);

var fileStream = new System.IO.FileStream(_filename, System.IO.FileMode::Create, System.IO.FileAccess::ReadWrite);
stream.CopyTo(fileStream);
stream.Close();
fileStream.Close();
//url = File::SendFileToTempStore(fileStream, _filename, classstr (FileUploadTemporaryStorageStrategy));
//new Browser().navigate(url, true);
}

SysEmailTable::sendMail("PendingPO", "en-us", "Test@Test.com", templateToken, _filename);
}

Please note that:
The file must be in this path or a subfolder in the path to got sent by sendMail:
SysEmailParameters::find().AttachmentsPath

According to this condition which is inside sendMail:
if (System.IO.File::Exists(htmlDecodedFileName) &&
((new System.IO.FileInfo(htmlDecodedFileName)).Length < (maxAttachmentSize * 1000000)) &&
SysEmailTable::isFromAttachmentsFolder(htmlDecodedFileName))

Was this reply helpful? Yes No