amitksingh Posted July 18, 2011 Share Posted July 18, 2011 Hi,I am using Jasper Report 3.1.4 for excel/pdf report generation in my web application.In one of the excel reports, I am getting one extra blank row. I have attached the generated report. In the report, two rows (2140 and 2141 are mergedd into one row). If I delete the row 2141, the report looks fine. So I assume that row 2141 is the blank row.In the java class, I am setting the JExcelApiExporter parameter asexporter.setParameter(JRxlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS, Boolean.TRUE);but even then I am getting the empty row. I have attached the jrxml file along with the excel report for reference. Link to comment Share on other sites More sharing options...
kusi Posted February 21, 2013 Share Posted February 21, 2013 After doing the following it was working for me properly (no more empty rows in excel export):1) Set param as mentioned before: exporterXLS.setParameter(JRXlsAbstractExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS, Boolean.TRUE); 2) Making the heigh of all fields exactly the same as the band they are located on 3) Setting the property "Stretch Type" for all fields on the band to the value "Relative to Band Height" for all fields on the band. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now