How to export my report to JSON format

Question:

I am trying to retrieve a report that has a simple table in it using the following call

http://<IP of my server>/jasperserver-pro/rest_v2/reports/Reports/restReportTest.json

and getting the 204 No Content response.

Answer:

You should prepare your report to be able to export it to json format.

For the detailed description of actions that should be done to achieve the desired result please refer to the JasperReports documentation:

http://jasperreports.sourceforge.net/sample.reference/subreport/index.html#jsonmetadataexport

From my part I would like to illustrate the document above with a sample of report that utilizes the properties that are required to export it to JSON.

This report is a copy of AdHoc based report that is supplied with the software:

(this AdHoc View uses Supermart Domain and Foodmart PostgreSQL database as its data source,  to be able to run this report please also install these resources with the product)

/public/Samples/Reports/04._Product_Results_by_Store_Type_Report

Please find the updated copy of this report in the folder:

/public/export_to_json/04._Product_Results_by_Store_Type_Report

To make this report “exportable” to JSON format it was opened in JasperSoft Studio:

All reports fields were updated with the property:

net.sf.jasperreports.export.json.path

Below I quote an XML snippet that is related to the 1-st field (product name)

<property name="net.sf.jasperreports.export.json.path" value="product_name"/>

The same property was added to the rest of the fields in this report. To export this report to JSON format

rest_v2/reports

REST v2 API get request should be executed from your browser.

Below I quote a sample of URL that I used in my environment to test this solution:

localhost:8620/jasperserver-pro/rest_v2/reports/public/export_to_json/04._Product_Results_by_Store_Type_Report.json

Please pay your attention that .json extension was added to the report name to point to the application that export should be performed in JSON format.

Please find in the attachment to the article an exported copy of  the report and its jrxml body with the properties that are mentioned above.

export_to_json.zip

mainreportjrxml.txt