Comment: I noted your jrxml is using an additonal dataset, the report is accesing twice the db, it only need do it once! the data is dispayed in title section, should be placed in detail section.
I offer my Consulting Service to improve/modify/Create your Reports. I am a Software Engineer with +9 years working with JasperReports/Ireport/JasperServer integrated with Java Apps and Servlets,connecting with several DataSoruces like PostgresSQL, MySQL, MS SQL Server, MS Access, APIs, CSV Files, Excel Files, Json and JavaBeans. Designs include Subreports, Charts, Graphics, QR Codes, Bar Code, RTF, HTMl, Dynamic parameters, Internationalization, Resource Bundles, Fonts Libraries, Stored Procedures (MS SQL Server) and complex SQL queries implementation/Optimization. Experience with JasperServer defining Reports, calls to Subreports, Input Control Customization, Queries. I have developed Reports to clients in Malasya, Hong Kong, Honduras, Costa Rica, Colombia, Venezuela, Spain, Germany, Swiss, India, Greece, Netherlands, UK, Canada, USA. See my Portfolio about the Jasper Reports!
Best Regards
Eduardo Ramos
Venezuela
GMT -04:00