Skip to main content
Solved

Generate "Check Form with Remittance" Report(ap641000.rpx) Programmatically

  • 26 July 2023
  • 2 replies
  • 113 views

Hi all,

 

I want to generate “Check form with remittance”(ap641000.rpx) Report Programmatically. But in the usual way, I was unable to do that as it has no key parameters. 

Schema Builder of the report - Parameters Tab

I used to do report generation in the following way. But I can not apply this approach here as there are no key parameters here. Is there any alternative approach of doing this?

Dictionary<String, String> parameters = new Dictionary<String, String>();
parametersm"DocType"] = apInvoice.DocType;
parametersm"RefNbr"]  = apInvoice.RefNbr;

//Report Processing
PXReportSettings settings = new PXReportSettings("MA105000");

PX.Reports.Controls.Report report = ReportLoader.CheckIfNull(nameof(ReportLoader)).LoadReport("MA105000", null);
                                 ReportLoader.InitReportParameters(report, parameters, settings, false);

PX.Reports.Data.ReportNode reportNode = ReportDataBinder.CheckIfNull(nameof(ReportDataBinder)).ProcessReportDataBinding(report);

byte/] data = PX.Reports.Mail.Message.GenerateReport(reportNode, RenderType.FilterPdf).First();

string filename = "Test Report";

PX.SM.FileInfo file = new PX.SM.FileInfo(filename, null, data);

 

Additionally, there are few filters as below. But how can we pass values there?
 

 

2 replies

Leonardo Justiniano
Rank
Userlevel 6
Badge +5

Hi @charithalakshan49 

Report implementation is low level stuff in Acumatica and the filtering you are asking to access has no evident references.

I see 2 possible options:

  • Modify the report (A copy with another ID) and add the parameters and filtering you need (I would do this one)
  • Work with result sets compatible with the entities of the report. You have the option to generate the records in code and pass them to the report.

 

 

 

Leo
C
Rank
Userlevel 4
Badge +1

Hi @Leonardo Justiniano Thank you for your suggestions. 

Reply


Terms & ConditionsCookie settings