Jasper Report with OpenERP 7.0
Jasper Report & iReport with OpenERP 7.0 in Ubuntu 12.04
JasperReport Server
- Install Jasper Report Server (http://sourceforge.net/projects/jasperserver/, http://jasper-bi-suite.blogspot.com/2014/01/installing-jasper-server-in-aws-ec2.html)
- cd ~/jasperreports-server-cp-5.5.0a
- $./ctlscript.sh start
- http://localhost:8080/jasperserver/
- Username // Password => jasperadmin // jasperadmin
- add new Project Folder
- add New Resource (Data Source)
7. Test Connection ok!
iReport
1. $cd ~/iReport-5.5.2/bin/
2. $./ireport
3. Create New Report File
2. $./ireport
3. Create New Report File
4. Save name (.jrxml) and location, then click finish button
5. Name : New Connection
– Select Database JDBC connection
– Select Database JDBC connection
JDBC Driver : PostgreSQL (org.postgresql.Driver)
JDBC URL : jdbc:postgresql://localhost:5432/DATABASE_NAME
Username : openerp
Password : openerp
Test connection OK!
6. create new report by selecting any fields you want from sql query
7. Design report and Preview your output data
8. Window > JasperReports Server Repository
9. Create New JasperReport Server Repository
ID : Repository Name
JasperReport Server URL : http://localhost:8080/jasperserver/services/repository
Username : jasperadmin
Password : jasperadmin
10. Create new folder in Repository Server (1 Folder for 1 Project)
11. Create Data Source file in Data Source Folder
12. click Data Source Details tab > Import from iReport > select a JDBC Data Source
13. click General tab
ID : datasource_ID
Name : Datasource Name
ID : datasource_ID
Name : Datasource Name
14. Add JasperServer Report
ID : form_id
Name : Form Name
ID : form_id
Name : Form Name
15. click Get Source from current opened report button, then click Next >
16. select Datasource, then Finish
17. Back to Jasper Report Browser, click on Project Folder, double click on Form, then Report output will be shown up.
