I find it hard to create highly customized report in ERPNext default tools when creating report so I tried to solve it using Jasper Report Server.
In this blog I will show you how I achieved to integrate ERPNext to Jasper Report Server.
Happy Learning!
I find it hard to create highly customized report in ERPNext default tools when creating report so I tried to solve it using Jasper Report Server.
01 - Install Jasper Server on Linux- step by step
In this video, I will show you easy steps to install Jasper Server.
1. Download Jasper server installer
>wget https://sourceforge.net/projects/jasperserver/files/JasperServer/JasperReports%20Server%20Community%20Edition%208.2.0/TIB_js-jrs-cp_8.2.0_linux_x86_64.run
2. Make the file executable
>chmod +x TIB_js-jrs-cp_8.2.0_linux_x86_64.run3. Run the installer and follow the installation wizard
>./TIB_js-jrs-cp_8.2.0_linux_x86_64.run4. Go inside the directory
> cd jasperreports-server-cp-8.2.0/
5. Start the service
>./ctlscript.sh start
02 - Configuring Jasper Server to use ERPNext Database as data source
Jasper server need a data source where the data will be pulled. In this video I will show you how to configure Jasper server data source which is in our case its ERPNext database.
03 - Configuring Jasper Studio with ERPNext and Jasper Server
Jasper Studio is the report designer tool for creating forms and reports for Jasper server. In this video I will show you how to configure Jasper Studio to connect to our ERPNext database so that when we are designing the report we are able to get the data from ERPNext.
In addtion, I will show you here how to configure Jasper Studio to connect to Jasper server for easy deployment of report.
04 - Creating the First Report
In this video, I will show you how to create a basic report using Jasper Studio and deploy it to Jasper server .
05 - ERPNext Integration with Jasper Report Server
This is the fun part of ERPNext's and Jasper Server. In this video, I will show you the steps how to integrate ERPNext with Jasper Server.