Developing Report on Jasper Report Studio

Reporting is very important item in every industry. And also reporting is very dynamic change from time to time base on business requirement. Jasper report server provide the facility to allows user to customer report as per requirement. In previous posting, I have show how to install jasper report server on Ubuntu. Next is to develop report and deploy into report server. To create report, I will use jasper report studio to create report and connect to report server.

1. Install Jasper Report Studio
2. Create Datasource
3. Connect to Remote Report Server
4. Create report
5. Deploy Report to Report Server
6. Reference

Environment setup as

• OS Windows Pro 10
• Java Virtual Machince 1.8
• Jasper Report Studio

1.Install Jasper Report Studio

First, download jasper report studio from here

Next is to install report studio. After installation, you shoule be able to start report studio as below.

After installation is completed. I will creating report project.

2.Create Report Project, Report and Datasource on Report Studio

To create report project, go to "File" -> "New" -> "Project"

Create Report Project

Input Project's name

Then, creating datasource. For this post, I will create 2 datasource and most commonly used includes jdbc/jndi datasource and webservice SOAP/RESt datasource.

Create JDBC datasource

To create JDBC datasource in the server just follow below step.

1. Go to repository explorer, right click on Data Adapters and select create data adapters

   

   Create Database JDBC Connection

2. Select Database JDBC Connection, input connection information and add JDBC library. Once finish then test the connection.

   

   Input Connection Information - 01

   

   Setting up Driver for JDBC

   

   Then, next is to create report from created JDBC datasource. the process to create report is below.

   

   Click right and select new report

   

   Put SQL Statement to retrieve data

   

   Select Data to show in the report

   

   Click finish

   

   Adjust the layout of report

   

   Preview the result

Create Web Service Datasource

To create Webservice Database, you need to install plugin into Jasper Report Studio. So, First is install plugin into Report Studio.

1. Download plugin from here

   

2. Unzip downloaded file jaspersoft_webserviceds_v1.5.zip

   

3. Inside unziped jaspersoft_webserviceds_v1.5 folder, go into JSS. Copy all jar files under this folder into jasper report studio plugin folder (i.e.C:\Program Files\TIBCO\Jaspersoft Studio-6.5.0.final\dropins\eclipse\plugins) as below.

   
   

4. Next is restarting jasper report studio

After you finish installing pluging for Jasper Report Studio, you should be able to create Webservice Datasource. To create webservice datasource, you could following step.

1. Go to Repository Explorer, Data Adapters and Right click to create Data Adapter. You should see Webservice datasource

   

2. Fill in webservice information, you could use RESTFul or SOAP Webservice

   
   

4.Create report

Once finish creating report project and datasource, next is to create report. Creating report is very easy, just go to project explorer, right click new and Jasper Report. Then you can follow following step.

First, I will create report with JDBC datasource

Create Report with RESTful Webservice datasource

Creating report with SOAP Webservice Datasource

Once dataset is in the field,creating report is just drugging and dropping to the report. And report can be previewed instantly.

6.Reference

1. Installing the Webservice Datasource
2. Webservice Datasource Documentation
3. Creating and Using Database JDBC Connections