HOWTO: Save SSRS Report to Excel from X++

Ussally you have to save a report to an output file for example store it or send it over mail.

Here an example to save a report into Excel format

SrsReportRunController          controller = new SrsReportRunController();
ReportContract   contract = new ReportContract();

controller.parmReportName(ssrsReportStr(ReportName, Report));

controller.parmShowDialog(false);
controller.parmReportContract().parmPrintSettings().printMediumType(SRSPrintMediumType::File);
controller.parmReportContract().parmPrintSettings().fileFormat(SRSReportFileFormat::Excel);
controller.parmReportContract().parmPrintSettings().overwriteFile(true);
controller.parmReportContract().parmPrintSettings().fileName(fileName);

controller.parmReportContract().parmRdpContract(contract);
contract.parmXYZ(_parmXYZValue);

controller.startOperation();