Generate Report in java using DynamicReports and JasperReports

Generate Reports in java using DynamicReports and JasperReports

This example shows you how to generate a simple report using DynamicReports and JasperReports

For developing this you must need to download DynamicReports the library and include it into their classpath. It allows you to produce documents that can be exported into many popular formats, It is based on JasperReport library.

1 : Create a DataSource and use it into report generation as

Class.forName(“com.mysql.jdbc.Driver”);

Connection con=DriverManager.getConnection(“jdbc:mysql://hostname:port/dbname”,”username”,”password”);

2 : Suppose mysql server contains a database test having table customer having fields

The table customer having fields

Column name	Data type
id	int
first_name	varchar(50)
last_name	varchar(50)
Created_date	datetime
age	int

We will create  report that will get all customers from the table and the data will be put into the report.

3 :Create a empty report object

JasperReportBuilder report = DynamicReports.report();

4: Now create a report colum for each database column

Columns.column("Customer Id", "id", DataTypes.integerType());

Where first parameter is column level

Second parameter is actual table field which is same as table column name.

Third parameter is datatype

5 : Add the report columns.

report

  .columns(

    Columns.column("Customer Id", "id", DataTypes.integerType()),

    Columns.column("First Name", "first_name", DataTypes.stringType()),

    Columns.column("Last Name", "last_name", DataTypes.stringType()),

    Columns.column("Created Date", "date", DataTypes.dateType()))

    Columns.column("Customer Age", "age", DataTypes.integerType()))

6 : Add a title text and page number to a report

.title(//title of the report

    Components.text("SimpleReportExample")

      .setHorizontalAlignment(HorizontalAlignment.CENTER))

  .pageFooter(Components.pageXofY())//show page number on the page footer

7 : Finally set the datasource query and connection

.setDataSource("SELECT id, first_name, last_name, created_date,age FROM customers ", connection);

Now below the full example here.

SimpleReportTest.java

import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import net.sf.dynamicreports.jasper.builder.JasperReportBuilder;
import net.sf.dynamicreports.report.builder.DynamicReports;
import net.sf.dynamicreports.report.builder.column.Columns;
import net.sf.dynamicreports.report.builder.component.Components;
import net.sf.dynamicreports.report.builder.datatype.DataTypes;
import net.sf.dynamicreports.report.constant.HorizontalAlignment;
import net.sf.dynamicreports.report.exception.DRException;
public class DynamicSimpleTest {
  public static void main(String[] args) {
            Connection connection = null;
            try {
                        Class.forName("com.mysql.jdbc.Driver");
                        connection = DriverManager.getConnection(
                    "jdbc:mysql://localhost:3306/test","root", "admin123");
            } catch (SQLException e) {
                        e.printStackTrace();
                        return;
            } catch (ClassNotFoundException e) {
                        e.printStackTrace();
                        return;
            }
            JasperReportBuilder report = DynamicReports.report();//a new report
            report
              .columns(
                  Columns.column("Customer Id", "id", DataTypes.integerType()),
                  Columns.column("First Name", "first_name", DataTypes.stringType()),
                  Columns.column("Last Name", "last_name", DataTypes.stringType()),
                  Columns.column("Created_date", "created_date", DataTypes.dateType()),
                  Columns.column("Customer Age","age",DataTypes.integerType()))
                 

              .title(//title of the report
                  Components.text("SimpleReportExample")
                          .setHorizontalAlignment(HorizontalAlignment.CENTER))
                          .pageFooter(Components.pageXofY())//show page number on the page footer
                          .setDataSource("SELECT id, first_name, last_name, created_date,age FROM customers",
                                  connection);

            try {
                //show the report
                        report.show();

                //export the report to a pdf file
                        report.toPdf(new FileOutputStream("d:/report1.pdf"));
            } catch (DRException e) {
                        e.printStackTrace();
            } catch (FileNotFoundException e) {
                        e.printStackTrace();
            }
  }

After Running It, It generates a report in pdf as below.

Output is here :