Search Here

Pages

Wednesday, 1 November 2017

How to add report datasource in ireport designer

This article is related to jasper reports, before creating reports in jasper using iReport designer we need to add report data-source. It means that from which source report data comes. I will show you how to add report data source in iReport designer step by step.



1- Open Jaspersoft iReport Designer and click on "Report Datasource" icon.

How to add report datasource in ireport designer

2- Connections/ Datasource dialog box will open. From this click on "New" button.

How to add report datasource in ireport designer

3- Another dialog box will open from here select first option "Database JDBC Connection" and click "Next".

How to add report datasource in ireport designer


4- Now add your credentials for "Database JDBC Connection".

  • Name -- your data source name
  • JDBC Driver -- select "PostgreSQL (org.postgresql.Driver)" in case of PostgreSQL
  • JDBC URL -- jdbc:postgresql://localhost:your_port_number/DatabaseName 
  • Username -- database user
  • Password -- user password


How to add report datasource in ireport designer

After adding above credentials click on "Test" button to check your connection success/failed status and than click on "Save" button to finish your data source connection. 

2 comments:

  1. how i can integrate jasper report iReport pass by parameter with JDBC IN odoo 8/9?

    ReplyDelete
    Replies
    1. To integrate jasper with odoo you need to create your custom module. That will call jasper reports. You need lot of codng stuff to do that.

      Delete