Finance | Project Operations, Human Resources, ...

Call and email a report by X++

(0) Share

Report

Posted on by Community Member

Dear community members,

I tried to search the forums for a sample of using X++ to call a D365 Finance & Operations report and then email it, but can't seem to find a good place to start.

Basically I am trying to use code to call vendor payment advice report and email it to a vendor email address.

thank you all for reading and helping!

Fen

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Martin Dráb 237,998 Most Valuable Professional on at

Like (0)

Report
Here is an example:

SrsReportRunController controller = new SrsReportRunController(); controller.parmReportName(ssrsReportStr(SysUserRoleInfo, Report)); controller.parmShowDialog(false); SRSPrintDestinationSettings settings = controller.parmReportContract().parmPrintSettings(); settings.printMediumType(SRSPrintMediumType::Email); settings.fileFormat(SRSReportFileFormat::PDF); settings.fileName('SysUserRoleInfo.pdf'); // Here we configure the email SrsReportEMailDataContract emailContract = new SrsReportEMailDataContract(); emailContract.parmTo("user@example.com"); emailContract.parmSubject("Security report"); emailContract.parmBody("Hi there! Here is your report."); settings.parmEMailContract(emailContract); controller.startOperation();

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Fen,

You don't need to use X++ for that but can make use of the business reports and electronic reporting. There are build in standard features to send them automatically out by email.

Best regards,

Ludwig

Was this reply helpful? Yes No
Camilo Fer 12 on at

Like (0)

Report

Hi Martin,

I'm using the code that you show like example and works fine from a job (only for test); but when I use a web service it doesn't due to the default email to send.

how can I set a "from email address"?

Thanks for your help!

Was this reply helpful? Yes No
Martin Dráb 237,998 Most Valuable Professional on at

Like (0)

Report

Hi Camilo, please never describe your problem by mere "it doesn't work", because there is no universal solution for all possible problem. We need to know what happens in your particular case.

What did you find when you debugged your web service?

Was this reply helpful? Yes No