Microsoft Dynamics AX (Archived)

Printing reports from code in AX2012 X++

(0) Share

Report

Posted on by Community Member

Am trying to print customer aging report.

i refer this link : http://dev.goshoom.net/en/2018/10/printing-reports-from-code-in-d365fo/

I am using contract class this one is working fine.

My scenario i need to run specific customer in customer aging report like Dynamic or Query filter.

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Community Member on at

Like (0)

Report
Copy link

Link copied!

This is my code :

Args args;

SrsReportRunController controller = new SrsReportRunController();

CustAgingReportContract rdpContract = new CustAgingReportContract();

SRSPrintDestinationSettings settings;

CurrencyCode currencyCode = "INR";

CustTable custTable;

custTable = CustTable::find("C003");

// Define report and report design to use

controller.parmReportName(ssrsReportStr(CustAgingReport, DesignWithNoDetailAndNoTransactionCur));

// Use execution mode appropriate to your situation

controller.parmExecutionMode(SysOperationExecutionMode::Synchronous);

// Suppress report dialog

controller.parmShowDialog(false);

//Explicitly provide all required parameters

rdpContract.parmZeroDate(systemDateGet());

rdpContract.parmStartDate(str2Date("12/1/2017",213));

rdpContract.parmDateTransactionDuedate(DateTransactionDuedate::TransactionDate);

rdpContract.parmAgingBuckets("30-60-90-120");

rdpContract.parmPrintAgingBucketDescription(NoYesCombo::No);

rdpContract.parmInterval(0);

rdpContract.parmPeriod(DayMonth::Day);

rdpContract.parmDirection(ForwardBackwardPrinting::Forward);

rdpContract.parmExcludeZeroBalanceCustomer(NoYes::Yes);

rdpContract.validate();

args = new Args();

args.record(custTable);

controller.parmReportContract().parmRdpContract(rdpContract);

controller.parmArgs(args);

// Change print settings as needed

settings = controller.parmReportContract().parmPrintSettings();

settings.printMediumType(SRSPrintMediumType::File);

settings.fileFormat(SRSReportFileFormat::PDF);

settings.fileName(@'C:\Test\AgingReportCustAging.pdf');

// Execute the report

controller.startOperation();

Was this reply helpful? Yes No
Verified answer

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

Like (0)

Report
Copy link

Link copied!
First of all, let me format and clean up your code, so it's easier to follow. next time, please use </> button in the rich formatting view to paste source code.

Args args; SrsReportRunController controller = new SrsReportRunController(); CustAgingReportContract rdpContract = new CustAgingReportContract(); SRSPrintDestinationSettings settings; // Define report and report design to use controller.parmReportName(ssrsReportStr(CustAgingReport, DesignWithNoDetailAndNoTransactionCur)); // Use execution mode appropriate to your situation controller.parmExecutionMode(SysOperationExecutionMode::Synchronous); // Suppress report dialog controller.parmShowDialog(false); //Explicitly provide all required parameters rdpContract.parmZeroDate(systemDateGet()); rdpContract.parmStartDate(mkDate(1, 12, 2017)); rdpContract.parmDateTransactionDuedate(DateTransactionDuedate::TransactionDate); rdpContract.parmAgingBuckets("30-60-90-120"); rdpContract.parmPrintAgingBucketDescription(NoYesCombo::No); rdpContract.parmInterval(0); rdpContract.parmPeriod(DayMonth::Day); rdpContract.parmDirection(ForwardBackwardPrinting::Forward); rdpContract.parmExcludeZeroBalanceCustomer(NoYes::Yes); rdpContract.validate(); args = new Args(); args.record(CustTable::find("C003")); controller.parmReportContract().parmRdpContract(rdpContract); controller.parmArgs(args); // Change print settings as needed settings = controller.parmReportContract().parmPrintSettings(); settings.printMediumType(SRSPrintMediumType::File); settings.fileFormat(SRSReportFileFormat::PDF); settings.fileName(@'C:\Test\AgingReportCustAging.pdf'); // Execute the report controller.startOperation();

By the way, notice how I've replaced str2Date("12/1/2017",213) with simpler mkDate(1, 12, 2017).

Now, you your question. You should be able to get the report contract by this:

controller.parmReportContract().parmQueryContracts().lookup(controller.getFirstQueryContractKey()));

Was this reply helpful? Yes No
Suggested answer

Rustem Galiamov 8,072 on at

Like (0)

Report
Copy link

Link copied!

Hi Gnanaprakash!

You can create a class with dialog. docs.microsoft.com/.../using-classes-to-create-a-dialog

Was this reply helpful? Yes No