OpenEdge ABL and Telerik Report

[Jon]

Hi

I'd like to programmatically (from an OpenEdge ABL procedure) run a Telerik Report (TRDP file) that has been saved on disk.

I'd also like to point that report file to 2 datasources at runtime that are also on disk "invoiceHeader.json" and "invoiceLines.json". 

The output must be a PDF file.

Please can you point me in the right direction.

Many thanks

Jon

 

[Todor]

Hi Jon,

I noticed that you have raised the same questions in a Support ticket I already addressed. Here is my reply for the benefit of our community:

Let me start with passing the JSON data to the declarative report definition. The suggested approach is described in the following KB articles:

• How to set the content of JsonDataSource through report parameter
• Set the File Path of JSON or CSV DataSource Through Report Parameter

You may use the Header data in a List/Table in the Report Header to be rendered once.

You may assign detailed data to the Report or another List/Table inside it to render all the details based on the incoming data.

When you want to create files for multiple invoice numbers, you may pass the invoice number as a Report Parameter to the report and generate it based on this number, for example, by reading different JSON files or filtering the JSON data.

Regarding exporting to PDF, you may do it with the ReportProcessor class as explained in the article Generating Reports Locally with Code.

When it comes to the integration with ABL, you may find more details in the KB article How to run a Telerik report from ABL?

Regards,
Todor
Progress Telerik