I have been thinking to compile a document which outlines the complete process of installation and setup of the connection because generally when one starts they do not find much of material and they tend to get stuck on a trivial issue.
So the post will have two portions, namely Installation and Setup.
So the post will have two portions, namely Installation and Setup.
Installation
This document will apprise you with the basic installation software, which would act as a prerequisite to run Jasper Report.
- Java –
As Jasper Reports is built on Java platform, so a proper installation of Java Development kit (jdk) is required. For official steps to install java one can refer to the link
https://www.java.com/en/download/help/windows_manual_download.xml - iReport Designer –
This is a third party Jasper Report designing software. iReport is the most popular visual designer tool for JasperReports Library and JasperReports Server (Business Intelligence).
The software can be downloaded in an exe run able format for windows machine, or other types of files as per the platform demands.
http://community.jaspersoft.com/project/ireport-designer/releases - Jasper Server –
This is the software which acts as the interface which provides web touch to the reports rather makes it interactive in terms of external links and the drill downs
Below is the link from where the file could be downloaded.
http://community.jaspersoft.com/project/jasperreports-server/releases - Database Server -
The database server or the datasource which serves the purpose of feeding data to the report, in this projects case the setup was in the SQL Server 2008, which could vary from project to project .
- Netbeans(Optional) –
Netbeans is the development environment where in you could create sciptlets for customization purposes in the Jasper Reports. You could even go on to make customizations on the charts, where in you could use the
https://netbeans.org/downloads/ (Download the SE version)
https://netbeans.org/downloads/ (Download the SE version)
Setup and Connection
Below are the steps for the setup, which would act as a prerequisite to run Jasper Report.
- Java –
Download and install java 7, please do mind not to install Java 8 as it is yet not supported by iReport. - iReport Designer –
After installing the iReport, first thing you need to do is that the inclusion of java connector
Below is the process to include the Java Connector
i. Download the Java connector for the Datasource, as we have the SQL Server datasource we need to download
http://www.java2s.com/Code/Jar/s/Downloadsqljdbc120jar.htm
For more info on the Connector follow the link -- https://docs.oracle.com/cd/E19501-01/819-3658/gcfoy/index.html
ii. Navigate to Tools—> Options Classpath
And select the Add JAR, and then browse to the downloaded path of the connector
Now we need to add a JDBC datasource
i. Click on the icon shown below on the top of the iReport window
- ii. In the popup select New Select The Datasource type as Database JDBC Connection
iii. Now Enter the name of the connection, select the SQL Server driver and enter the name of the database in the url of the database, also key in your credentials, refer to the screenshot below
http://3.bp.blogspot.com/-gQJwYs6Argo/VLO_PzUbtWI/AAAAAAAAGuQ/KQjjPVKrXEI/s1600/xs1.png
iv. Now test the connection, it will say the connection successful.
We are now ready to create reports. - Jasper Server –
After installation in order to run Jasper Server open the browser and key in
localhost:8080/jasperserver
Then login using the credentials jasperadmin/jasperadmin
Then setup the connection, righ click on the node and add a datasource
Enter the details below, for the connector and setup the datasource.
The above steps are pretty basic and gives a fair idea as to what all basic necessities are there to process the installation and setup.
Recommended Comments
There are no comments to display.