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

  3. 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

  4. Save and publish the report to server
  5. Provide the following rest API to get the json export
    “http://localhost:8081/jasperserver-pro/rest_v2/reports//.json”
  6. 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”
logo

Free Open Source BI Platform

logo
  • AI-Powered Analytics
  • Embedded Analytics
  • Single Sign-On (SSO)
  • Multi-Tenancy
  • Paginated Canned Reporting
  • Interactive Dashboard
  • White Labeling

0 0 votes
Article Rating
Subscribe
Notify of
0 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments