Basics on JasperReports

1. Open Source Java Reporting Engine
2. Can export to PDF, HTML, XLS, RTF, ODT, CSV, TXT, and XML files.
3. .jrxml is the design xml for Jasper Reports
4. .jasper is the executable to run the report.

Creating Data Adapter: Data Adapter is the data source connection that we will have to establish to run the report.

Data Adapter Options: There are several options to connect to various type of datasources. I have selected JDBC.

Connection Details Provide the Connection details as listed below.

1. JDBC Driver
2. JDBC Url
3. Username
4. Password

Driver Classpath: Browse and select the appropriate driver jar for your database connection. I have selected postgres jar as I am going to connect to Postgress

Test the Connection: Test the connection and on success click Finish. You are all set with your Data Adaper.

Creating New Report:

Select the Page from the predefined templates.

Name the report like “MyFirstReport.jrxml”

Create the query that you are going to use to fetch the data

Add the Query by selecting the right Data Adapter

Select all the fields you want to use in the report.

Report Bands:

1. Title contains the 'Title' of the report. It appears only once at the very beginning of the report.
2. Page Header may contain date and time information and/or organization name. This appears at the top of each page.
3. Column Header lists the names of those specific fields, which you want to display in the report
4. Detail is the part where entries of the specific fields (listed in Column Header) are shown
5. Column Footer may display summation of any of the field
6. Page Footer may contain page count information. It appears at the bottom of each page
7. Summary contains information inferred from "detail" part, for example, after listing the number of hours, worked by each author, total hours worked by each author can be put in visual chart like pie chart, graph, etc. for better comparison

Fields: Report fields are elements, which represent mapping of data between datasource and report template. Fields can be combined in the report expressions to obtain the desired output. A report template can contain zero or more elements. When declaring report fields, the data source should supply data corresponding to all the fields defined in the report template. Example.

Parameters: Report Parameters are the object references, those are passed during report-filling operations to the report engine. The data which cannot be passed through the data source, can be passed by using parameters. Data like emp_id can be passed through parameters. A JasperReports template or JRXML template can have zero or more parameter elements. Example.

Variables: Report variables simplify the following tasks −

1. Report expressions, which are heavily used throughout the report template. These expressions can be declared only once by using the report variables.
2. Report variables can perform various calculations based on the corresponding expressions values such as count, sum, average, lowest, highest, variance, etc. If variables are defined in a report design, then these can be referenced by new variables in the expressions. Hence, the order in which the variables are declared in a report design is important. Examples: Average, Count, First, Highest, Lowest and Sum, etc.

You can drag and drop the components you want.

1. Add the fields in the Detail Band.
2. Add the static text in the Page Header Band.
3. Add a static tex in the Title Band.

Output Generated As below.

Notes:

1. You need to place the MyFirstReport.jrxml into your local repository which available under resources/templates
2. Update the your local path in ReportingServiceImpl.java

Resources:

https://www.tutorialspoint.com/jasper_reports/

https://o7planning.org/en/10271/jasperreport-tutorial-for-beginners

https://o7planning.org/en/10293/calling-jasper-report-from-java-application