How to export the jasper report into JSON format

Posted on by By admin, in Jaspersoft | 0

  1. Create a tabular report by using database.
  2. To fetch the data by date wise add ‘startdate and enddate’ parameters
  3. Make data easy with Helical Insight.
    Helical Insight is the world’s best open source business intelligence tool.

    Grab The 30 Days Free Trail

  4. To export the data into JSON
    I. Click the Text Field Properties
    II. Next Click on edit properties

    III. Set Property name as “net.sf.jasperreports.export.json.path”
    IV. Set value as “merchantid”
    V. Repeat the same process for all text fields
  5. Save and publish the report to server
  6. Provide the following rest API to get the json export
  7. Ex: “http://localhost:8080/jasperserver-pro/rest_v2/reports/BCT/Reports/Merchant_Report_by_Datewise.json?MerchantID=1234&Startdate=2021-01-01&Enddate=2021-12-31”

Best Open Source Business Intelligence Software Helical Insight is Here


A Business Intelligence Framework

0 0 votes
Article Rating
Notify of
Inline Feedbacks
View all comments