The integration of JasperReports to MHG ERP System
Pisarenko, Ruslan (2010)
Pisarenko, Ruslan
Mikkelin ammattikorkeakoulu
2010
All rights reserved
Julkaisun pysyvä osoite on
https://urn.fi/URN:NBN:fi:amk-2010060111109
https://urn.fi/URN:NBN:fi:amk-2010060111109
Tiivistelmä
MHG Systems is a provider of ERP systems for businesses working in Bioenergy area. The MHG ERP Reporting module is an important part of the ERP system. The module is implemented in Java programming language and is built on Java EE framework. The main function of the module is generation of Excel documents, based on data from the database. The Excel documents featuring reports on the different activity of ERP users and are implemented in a form of Excel tables. The original module is utilizing JXLS framework to provide Excel functionality.
The aim of the project was to research and prove the possibility for usage of JasperReports framework for generation of Excel documents, as the JXLS framework proved to be unreliable and unstable. The module needed to be modified to enable this functionality. The theoretical part of the thesis describes the concepts and technologies used during the implementation of the application. The utilized technologies include MySQL database management system, Glassfish application server and Java Enterprise Edition technologies, such as Servlet API, Java Server Pages, Java Server Faces, IceFaces and Java Beans. The Spiral method of software development was used to develop the application. The practical part describes the prototyping process of application development. The development of the project also included creation of the test database and ERP classes that the module is communicating with. Because the source code of the Reporting module is confidential, the later stages of development are described in general manner, though all the principles and techniques on which the module is built are described in great detail.
As a result of the project a showcase MHG ERP Reporting module was created. The module was developed to demonstrate the complete functionality on example of one report type. During the development process the principle of enabling advanced JXLS functionality with JasperReports framework was developed. This method can be useful for any project that built around migration from JXLS to JasperReports framework involving advanced JXLS templates.
The project showed the possibility of migration from JXLS to JasperReports framework with retention of full functionality. The functionality of MHG ERP Reporting module was further advanced with introduction of graphical elements in Excel reports.
The aim of the project was to research and prove the possibility for usage of JasperReports framework for generation of Excel documents, as the JXLS framework proved to be unreliable and unstable. The module needed to be modified to enable this functionality. The theoretical part of the thesis describes the concepts and technologies used during the implementation of the application. The utilized technologies include MySQL database management system, Glassfish application server and Java Enterprise Edition technologies, such as Servlet API, Java Server Pages, Java Server Faces, IceFaces and Java Beans. The Spiral method of software development was used to develop the application. The practical part describes the prototyping process of application development. The development of the project also included creation of the test database and ERP classes that the module is communicating with. Because the source code of the Reporting module is confidential, the later stages of development are described in general manner, though all the principles and techniques on which the module is built are described in great detail.
As a result of the project a showcase MHG ERP Reporting module was created. The module was developed to demonstrate the complete functionality on example of one report type. During the development process the principle of enabling advanced JXLS functionality with JasperReports framework was developed. This method can be useful for any project that built around migration from JXLS to JasperReports framework involving advanced JXLS templates.
The project showed the possibility of migration from JXLS to JasperReports framework with retention of full functionality. The functionality of MHG ERP Reporting module was further advanced with introduction of graphical elements in Excel reports.