Creating a Simple Report using JSON File in Jaspersoft Studio

Posted on by By Satya Gopi, in Jaspersoft | 1

Prerequisites: Jasper Studio 6.4.0

Database: Employee JSON

In this blog we will discuss how to implement a Jaspersoft Report using JSON file.

Make data easy with Helical Insight.
Helical Insight is the world’s best open source business intelligence tool.

Grab The 30 Days Free Trail

Step1: Take a Sample JSON with employee details

JSON Employee Details

Step2:  Create a New Report in Jasper Studio and give a name

New report in jasper studio

Step3: Click Next and then click on New button to create a JSON Datasource

create JSON Datasource

Step4: Click next, here we need to give JSON file location

JSON file Location

Step5: Click on test and it need to show test successful

Testing the Connection

Step6: Now we need to select the JSON Datasource and Click on the Object on Top of tree. (In my example i have double clicked on employees). The Employees will appear on the right side of the screen.

Make data easy with Helical Insight.
Helical Insight is the world’s best open source business intelligence tool.

Lets Start 30 Days Free Trail

JSON datasource object

Step7: Select the fields in the next window

Select the fields

Step8: Create a Report Template and with fields we are selected above ,now drag that fields ‘and give some formatting

Report Template

Step9: Preview to see the Output

Final Output

In case if you have any queries please get us at support@helicaltech.com

Thanks,

Satya Gopi

Helical IT Solutions Pvt Ltd

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
1 Comment
Oldest
Newest Most Voted
Inline Feedbacks
View all comments

It is a pitty, that the most screenshots are unsharp.

0
Reply