Optimized “Jasper Reports”

Feature: Graphical representation of the reports. 
“Jasper Report” is one of the options that we choose for the graphically displaying reports. Jasper report is implemented with the help of jrxml file which acts as an editor for designing graphical report.

http://www.ensode.net/jasperreports_database_pg2.html

Problem 1: Speed
Reports were generated by performing various calculations on multiple result set. The delay was caused due to frequent connection to sql database.

Solution 1: Stored Procedures
Connection to the database is made once. All the result set and the different operations are performed under the SQL environment and the final result is returned.
 
Problem 2:
Static, which means that the number of series that we could show were fixed and only could be defined at design time.

Solution 2:
Jrxml file is an xml file. After analysing templates of various charts and its design configurations, we tried editing jrxml file at runtime and we were successful in doing that.