Change the filename of an SSRS report when emailed through X++

(0) Share

Report

Posted on by cjohnson300

213

I have the following code (excerpt only, not full method) to both email a SSRS report and save it as a file:

    // create email contract
    emailContract = new SrsReportEMailDataContract();
    
    // fill in the email contract details
    emailContract.parmAttachmentFileFormat(SRSReportFileFormat::PDF); 
    emailContract.parmSubject("My Report"); 
    emailContract.parmTo("someone@someone.com");   
    
    // email report
    certificateController.parmReportContract().parmPrintSettings().printMediumType(SRSPrintMediumType::Email);
    certificateController.parmReportContract().parmPrintSettings().parmEmailContract(emailContract);
    certificateController.parmReportContract().parmPrintSettings().fileFormat(SRSReportFileFormat::PDF);
    certificateController.parmReportContract().parmPrintSettings().fileName(tSaveParameters.CertificateUNCPath + '\\' +  fileNamePDF);
    
    certificateController.runReport();    
    
    // generate file for archiving
    certificateController.parmReportContract().parmPrintSettings().printMediumType(SRSPrintMediumType::File);
    certificateController.parmReportContract().parmPrintSettings().overwriteFile(true);
    certificateController.parmReportContract().parmPrintSettings().fileFormat(SRSReportFileFormat::PDF);
    certificateController.parmReportContract().parmPrintSettings().fileName(tMFilesParameters.FLW_MFilesCertificateUNCPath + '\\' +  fileNamePDF);

    certificateController.runReport();

When the email is received, the report as an email attachment is the AOT name of the report eg. Reportname.PrecisionDesign1.pdf

When the report is saved to a file share, it is the name I gave it.

Can I change the name of the attachment on the email, in the same way I change the name of the saved file?

Many thanks in advance!

*This post is locked for comments

I have the same question (0)

All responses (10)

Answers (0)

Sort by

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

Like (0)

Report
Copy link

Link copied!

Isn't the problem in the fact that you aren't providing a valid file name?

You use a path (not just a file name) when sending the file via e-mail, therefore you're trying to create an attachment called \\SomeLocation\MyReport.pdf, which isn't a valid file name. Instead, you should use something like MyReport.pdf. Give it a try and let's see...

Was this reply helpful? Yes No
cjohnson300 213 on at

Like (0)

Report
Copy link

Link copied!

Sorry, any one got any ideas?!

Was this reply helpful? Yes No
Suggested answer

Jie G Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi cjohnson300,

You can use

certificateController.parmReportContract().parmPrintSettings().fileName(fileNamePDF);

instead of

certificateController.parmReportContract().parmPrintSettings().fileName(tSaveParameters.CertificateUNCPath + '\\' + fileNamePDF);

I have tested and confirmed that certificateController.parmReportContract().parmPrintSettings().fileName(fileNamePDF) will set the attached PDF with the filename you gave it.

Was this reply helpful? Yes No
cjohnson300 213 on at

Like (0)

Report
Copy link

Link copied!
Thanks Martin.

As suggested, I changed the line to this:

certificateController.parmReportContract().parmPrintSettings().fileName('myreport.pdf');

but the email I received still has the attachment named as [report name].[Design name].pdf

Thanks for your help!

Was this reply helpful? Yes No
cjohnson300 213 on at

Like (0)

Report
Copy link

Link copied!

Hi

Many thanks for the suggestion, but as you can see from my later post, it didn't work for me, unless I did something else wrong?!

Was this reply helpful? Yes No
Jie G Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi cjohnson300,

Which version of AX 2012 are you using？ Which report are you sending as an attachment?

Please check the filename( ) of the SrsPrintDestinationSettings class.

/// <summary> /// Gets or sets the file name. /// </summary> /// <param name="_value"> /// The name of the file to set; optional. /// </param> /// <returns> /// The current file name. /// </returns> /// <exception cref="M:Exception::Error"> /// The directory does not exist. /// </exception> /// [DataMemberAttribute] public str fileName(str _value = fileName) { #WinAPI str directory; // if setter is called, then get directory and check if valid, else throw error. if (_value && !prmisDefault(_value)) { directory = System.IO.Path::GetDirectoryName(_value); // if the directory is empty then use the users temp path. if (!directory) { directory = SRSPrintDestinationSettings::getTempFilePath(); // create the file name by combining the temp path the filename. fileName = System.IO.Path::Combine(directory, _value); } else { if (printMediumType == SRSPrintMediumType::File && !System.IO.Directory::Exists(directory)) { throw error(strFmt("@SYS72247", directory)); } // if directory is valid, then just assign the value to member variable. fileName = _value; } // if file name is changed, user may be prompted for overwriting existing file; //pass false to allow this prompt to happen this.parmOverwriteFileIsSet(false); } return fileName; }

You can also set a break point and debug to trace the filename.

Was this reply helpful? Yes No
cjohnson300 213 on at

Like (0)

Report
Copy link

Link copied!

Using AX2012 R2 CU6 and the report is a bespoke report for our organisation.

At this point in the code, the filename is as I was hoping but I can only presume something else is overwriting it later?

Also, within the SRSReportRunController there is a number of variables set to the name of the report, I would expect one of these to be the name of the attachment? Does anyone know which method of which class does the actual attaching of the file and / or the sending of the email?

Was this reply helpful? Yes No
Suggested answer

Jie G Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi cjohnson300,

Here is the call stack when sending a standard report BankCodaDetails.

[c] \Classes\SysINetMail\sendMailAttachEx 37 [c] \Classes\SysINetMail\sendMailAttach 16 [c] \Classes\SrsReportRunMailer\emailReport 40 [c] \Classes\SrsReportRunPrinter\toEmail 36 [c] \Classes\SrsReportRunPrinter\printReport 38 [c] \Classes\SrsReportRunService\runReport 43 [c] \Classes\SrsReportRunImpl\runReport 7 [c] \Classes\SrsReportRunController\runReport 94 [c] \Classes\RdlItemTransController\main 21

Was this reply helpful? Yes No
cjohnson300 213 on at

Like (0)

Report
Copy link

Link copied!
Many thanks Ada

I have traced it as far as this method SrsReportDataContract::parmReportName

[DataMemberAttribute('ReportName')] public SRSCatalogItemName parmReportName(SRSCatalogItemName _reportName = reportName) { // if setter is called and the new report name is different than the existing name, then set the report path also. if(_reportName != reportName) { reportName = _reportName; reportPath = ''; // reset the path, so that next call to parmReportPath will get the new path. } return reportName; }

But the variables _reportName and reportName are the same (the wrong string!). I guess I need to set a DataMemberAttribute in the report?

Was this reply helpful? Yes No