kusi

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.

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.

I'm using JRBeanCollectionDataSource(objects) to pass the data into the report. This works very well. However, if the objects inside have a reference to another object and I would like to print the fields of this referenced object, I didn't found a way up until now. Of course, if the reference would be again a list of objects, I could make it with a subreport. But in this situation it isn't, it is only a simple reference to another object and I would like to print it's values. How could I define the fields of the referenced object within the report?

I retrieve it from the following maven2 repo: <repository> <id>maven2-repository.maven.org</id> <url>http://repo2.maven.org/maven2</url> </repository> With this dependency: <dependency> <groupId>net.sf.jasperreports</groupId> <artifactId>jasperreports</artifactId> <version>3.7.5</version> </dependency>