Share
Report
23I have customized standard Customer account statement report. Now the requirement is, need to send the customized report through email as attachment.
On a form by selecting From Date, To Date and customer account from grid, on clicking send email button it should send the report to all the selected customer accounts.
But i am getting this error when clicking on Send Email button.
I have written the below code by overriding clicked() method of button.
[Control(/Button/)]
class FormEmailButton
{
/// <summary>
/// Clicked method of button.
/// </summary>
public void clicked()
{
CustAccount accNum;
TransDate TDate, FDate;
CustTable custTable1;
CustTrans custTrans1;
CustInvoiceTable custInvTable;
CustAccountStatementExtContract contract = new CustAccountStatementExtContract();
SrsReportRunImpl srsReportRun;
ReportName rptName = /GOD_CustAccStatementExt.Report/;
#SRSFramework
SrsReportRunController controller = new SrsReportRunController();
//CustAccountStatementExtController custController = new CustAccountStatementExtController();
SRSPrintDestinationSettings settings;
Array arrayFiles;
System.Byte[] reportBytes = new System.Byte[0]();
SRSProxy srsProxy;
SRSReportRunService srsReportRunService = new SrsReportRunService();
Microsoft.Dynamics.AX.Framework.Reporting.Shared.ReportingService.ParameterValue[] parameterValueArray;
Map reportParametersMap;
SRSReportExecutionInfo executionInfo = new SRSReportExecutionInfo();
;
PrintJobHeader printJobHeader;
DocuRef docuRef;
DocuValue docuValue;
str TDay;
date Today;
;
super();
class FormEmailButton
{
/// <summary>
/// Clicked method of button.
/// </summary>
public void clicked()
{
CustAccount accNum;
TransDate TDate, FDate;
CustTable custTable1;
CustTrans custTrans1;
CustInvoiceTable custInvTable;
CustAccountStatementExtContract contract = new CustAccountStatementExtContract();
SrsReportRunImpl srsReportRun;
ReportName rptName = /GOD_CustAccStatementExt.Report/;
#SRSFramework
SrsReportRunController controller = new SrsReportRunController();
//CustAccountStatementExtController custController = new CustAccountStatementExtController();
SRSPrintDestinationSettings settings;
Array arrayFiles;
System.Byte[] reportBytes = new System.Byte[0]();
SRSProxy srsProxy;
SRSReportRunService srsReportRunService = new SrsReportRunService();
Microsoft.Dynamics.AX.Framework.Reporting.Shared.ReportingService.ParameterValue[] parameterValueArray;
Map reportParametersMap;
SRSReportExecutionInfo executionInfo = new SRSReportExecutionInfo();
;
PrintJobHeader printJobHeader;
DocuRef docuRef;
DocuValue docuValue;
str TDay;
date Today;
;
super();
FDate = GOD_FromDateSelected.dateValue();
TDate = GOD_ToDateSelected.dateValue();
contract = new CustAccountStatementExtContract();
TDate = GOD_ToDateSelected.dateValue();
contract = new CustAccountStatementExtContract();
for(custTable1 = getFirstSelection(CustTable_ds); custTable1; custTable1 = CustTable_ds.getNext())
{
PDFName = strFmt(/%1/,custTable1.AccountNum + /_/ +custTable1.BankAccount); //trFmt(@'C://Temp////%1.pdf ',custTable1.AccountNum);
contract.parmCustAccount(custTable1.AccountNum);
contract.parmFromDate(FDate);
contract.parmToDate(TDate);
controller.parmReportName(ssrsReportStr(GOD_CustAccStatementExt,Report));
controller.parmShowDialog(false);
controller.parmLoadFromSysLastValue(false);
controller.parmReportContract().parmRdpContract(contract);
settings = controller.parmReportContract().parmPrintSettings();
settings.printMediumType(SRSPrintMediumType::Archive);
settings.fileName(PDFName);
settings.fileFormat(SRSReportFileFormat::PDF);
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);
{
PDFName = strFmt(/%1/,custTable1.AccountNum + /_/ +custTable1.BankAccount); //trFmt(@'C://Temp////%1.pdf ',custTable1.AccountNum);
contract.parmCustAccount(custTable1.AccountNum);
contract.parmFromDate(FDate);
contract.parmToDate(TDate);
controller.parmReportName(ssrsReportStr(GOD_CustAccStatementExt,Report));
controller.parmShowDialog(false);
controller.parmLoadFromSysLastValue(false);
controller.parmReportContract().parmRdpContract(contract);
settings = controller.parmReportContract().parmPrintSettings();
settings.printMediumType(SRSPrintMediumType::Archive);
settings.fileName(PDFName);
settings.fileFormat(SRSReportFileFormat::PDF);
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());
reportBytes = srsproxy.renderReportToByteArray(controller.parmreportcontract().parmreportpath(),
parameterValueArray,
settings.fileFormat(),
settings.deviceinfo());
reportBytes = srsproxy.renderReportToByteArray(controller.parmreportcontract().parmreportpath(),
parameterValueArray,
settings.fileFormat(),
settings.deviceinfo());
}
It is throwing the exception for this line : srsReportRunService.preRunReport(controller.parmreportcontract());
please help me to get this resolved
All responses (
Answers (
