Microsoft Dynamics AX (Archived)

Export multiple PDF's from single SSRS report

(0) Share

Report

Posted on by Daljit Kaur Rahsi

1,260

Hi,

I have created a SSRS report which is running and I am able to export the report as a single PDF file.

Also, I have added a page break on the bases of Customer Account No.

Now my question is how can I print separate PDF on the bases of different customer account no. in the local directory?

I don't want to use the data-driven subscription, as it will run as we set the time; whereas I want the report to be exported whenever the client wishes to do so.

Version: Microsoft Dynamics AX 2012 R#, SSRS report 2010.

*This post is locked for comments

I have the same question (0)

All responses (13)

Answers (0)

Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

No, using standard AX, its not possible, as of today.

you can think of doing any customization (which can cost you too much time)

or you can think to develop report in away or call report in a way that you should call it once for 1 customer, save pdf then call report again for next customer

In standard AX most of reports are developed in same way. one prominent example is CustomerAccountStatement, which is very commonly used to send it to customers, by end of month. Microsoft has developed it in a way that it is run per customer and saved as pdf for each call of report.

and one more important point there is difference between SSRS and AX-SSRS.

AX flavored SSRS lacks too much which standard SSRS provides you. you cannot even think of data-driven subscription easily in AX.

As per my understanding the solution which can cost you least time, is to develop report in a way so that it can be called per customer and call it per customer and save PDF.

Stay connected for other's views on this post

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

I agree with Sohaib you have to do customization in report or you may have to run report multiple times for different customers by passing different customer account numbers.

Following sample code generates Purchase order confirmation PDF:

PSAPurchaseOrderController poConfirmationController;

PurchPurchaseOrderContract purchPOContract;

SRSReportExecutionInfo reportExecutionInfo;

Args args = new Args();

SrsReportRunImpl srsReportRun;

VendPurchOrderJour vendPurchOrderJour;

ReportName reportName = ssrsReportStr(PSAPurchaseOrder, Report);

str fileName;

;

select firstOnly vendPurchOrderJour

order by RecId desc

where vendPurchOrderJour.PurchId == '';//Replace with PurchOrder Id

if (!vendPurchOrderJour)

return '';

args.record(vendPurchOrderJour);

poConfirmationController= PSAPurchaseOrderController::construct();

poConfirmationController.parmArgs(args);

poConfirmationController.parmReportName(reportName);

reportExecutionInfo = poConfirmationController.parmReportContract().parmReportExecutionInfo();

purchPOContract= poConfirmationController.parmReportContract().parmRdpContract();

purchPOContract.parmRecordId(vendPurchOrderJour.RecId); // Record id must be passed otherwise the report will be empty

poConfirmationController.parmArgs(args);srsReportRun = poConfirmationController.parmReportRun() as SrsReportRunImpl;

fileName = System.IO.Path::Combine(WinAPIServer::getTempPath(), strFmt('purchConfirmation_%1.pdf', _purchId));

poConfirmationController.parmReportRun(srsReportRun);

poConfirmationController.parmReportContract().parmPrintSettings().printMediumType(SRSPrintMediumType::File);poConfirmationController.parmReportContract().parmPrintSettings().overwriteFile(true);

poConfirmationController.parmReportContract().parmPrintSettings().fileFormat(SRSReportFileFormat::PDF);

poConfirmationController.parmReportContract().parmPrintSettings().fileName(fileName);

poConfirmationController.runReport();

Was this reply helpful? Yes No
Daljit Kaur Rahsi 1,260 on at

Like (0)

Report

Hi Qureshi,

What are you including in the construct() method?

poConfirmationController= PSAPurchaseOrderController::construct();

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Nothing, PSAPurchaseOrderController construct method does not accept any parameters.

Was this reply helpful? Yes No
Daljit Kaur Rahsi 1,260 on at

Like (0)

Report

Hi Qureshi,

I have to create Customer Payment Journal Report, based on the code you provided I created one for the same:

I have created a class "CustPaymentJournal"

Created a method Custprocessfile(), which includes the following code:

static void CustprocessFile()

{

CustPaymentJournalController_NA customerpaymentjournalcontroller;

CustPaymentJournalContract_NA customerpaymentjournalcontract;

SRSReportExecutionInfo reportexecutioninfo;

Args args=new Args();

SrsReportRunImpl srsreportrun;

CustPaymentJournalTmp_NA customerpaymentjournal;

ReportName reportname=ssrsReportStr(CustPaymentJournal_NA,Report);

AccountNum accountnum;

str fileName;

;

select firstOnly customerpaymentjournal

order by RecId desc

where customerpaymentjournal.AccountNum=='';

if(!customerpaymentjournal)

return;

args.record(customerpaymentjournal);

customerpaymentjournalcontroller = CustPaymentJournalController_NA::construct();

customerpaymentjournalcontroller.parmArgs(args);

customerpaymentjournalcontroller.parmReportName(ReportName);

reportexecutioninfo = customerpaymentjournalcontroller.parmReportContract().parmReportExecutionInfo();

customerpaymentjournalcontract = customerpaymentjournalcontroller.parmReportContract().parmRdpContract();

customerpaymentjournalcontract.parmLedgerJournalTransRecId(customerpaymentjournal.RecId);

customerpaymentjournalcontroller.parmArgs(args);

srsReportRun = customerpaymentjournalcontroller.parmReportRun() as SrsReportRunImpl;

Filename = System.IO.Path::Combine(WinAPIServer::getTempPath(), strFmt('CustomerPaymentJournal_%1.pdf', AccountNum));

customerpaymentjournalcontroller.parmReportRun(srsReportRun);

customerpaymentjournalcontroller.parmReportContract().parmPrintSettings().printMediumType(SRSPrintMediumType::File);

customerpaymentjournalcontroller.parmReportContract().parmPrintSettings().overwriteFile(true);

customerpaymentjournalcontroller.parmReportContract().parmPrintSettings().fileFormat(SRSReportFileFormat::PDF);

customerpaymentjournalcontroller.parmReportContract().parmPrintSettings().fileName(Filename);

customerpaymentjournalcontroller.runReport();

}

//////////////////////////////////////

When I run the report, I get an empty report. Is there anything I am doing wrong or have to do something more to get the report?

Was this reply helpful? Yes No
Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

I can see two mistakes in your code

1) you have declared an object for temporary table

CustPaymentJournalTmp_NA customerpaymentjournal;

after declaring it, you are trying to get first record of this temp table and trying to pass it as args to controller class

select firstOnly customerpaymentjournal

order by RecId desc

where customerpaymentjournal.AccountNum=='';

100% its going empty record and as result you are getting nothing.

2) you are passing a non-relevant DataSource as args,

the underlying query of this report, is named as CustPaymentJournal_NA, this query has two DatSources named as LedgerJournalTable and LedgerJournalTrans. None of the dataSources under query is CustPaymentJournalTmp_NA; whereas you are passing a buffer of CustPaymentJournalTmp_NA as args to controller class

Was this reply helpful? Yes No
Daljit Kaur Rahsi 1,260 on at

Like (0)

Report

For the first one:

Should I use the LedgerJournalTrans table?

The reason I am using AccountNum as my field because I have added a page break based on the AccountNum.

Whereas AccountNum is not present in LedgerJournalTrans Table; whereas it has a method parmAccount().

Was this reply helpful? Yes No
Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

all I can understand from discussion is that you want to run report for specific customer, as you guys create journal for multiple customer and you wan to print report for one customer at a time.

kindly confirm my understanding about requirement, or specify by yourself, before we suggest you anything further.

Was this reply helpful? Yes No
Daljit Kaur Rahsi 1,260 on at

Like (0)

Report

I want to create a report for Customer Payment Journal.

The report is generated for all the customers in a single report; whereas when I export the report in PDF, I want it to create multiple reports for different customer.

How can I achieve this?

Was this reply helpful? Yes No
Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

okay, as of now

are you using a existing standard report?

or

you have your own customized report?

Was this reply helpful? Yes No