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.
2- Connections/ Datasource dialog box will open. From this click on "New" button.
3- Another dialog box will open from here select first option "Database JDBC Connection" and click "Next".
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
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
how i can integrate jasper report iReport pass by parameter with JDBC IN odoo 8/9?
ReplyDeleteTo 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