reports behave differently with different formats.

[avishek]

Hello Everyone,

 

I have developed few reports w.r.t. to PDF format, but their layout changes when I change the format of the report to(rtf, html, xls etc.). In PDF's it is working fine.

Please suggest how to keep the layout same in all the formats.

 

Regards,

Avishek Chakraborty

[lshannon]

Take a look at this FAQ:

http://www.jasperforge.org/jaspersoft/opensource/business_intelligence/jasperreports/faq.html#FAQ28

 

You will probably need to put some time into your design to ensure there are no overlapping elements and you are using a grid layout.

 

Also you can check out the excel exporter options:

http://www.jasperforge.org/jaspersoft/opensource/business_intelligence/jasperreports/config.reference.html#net.sf.jasperreports.export.xls.detect.cell.type

 

These can be set at the application level in the jasperreports.properties file or on a report by report basis by adding the properties to the JRXMLs manual.

 

Here is the set I start with, this can be pasted in the JRXML right under the import statements:

 

Code:

<property name="net.sf.jasperreports.export.xls.exclude.origin.band.2" value="pageFooter"/>

<property name="net.sf.jasperreports.export.xls.collapse.row.span" value="true" />

<property name="net.sf.jasperreports.export.xls.detect.cell.type" value="true" />

<property name="net.sf.jasperreports.export.xls.font.size.fix.enabled" value="true" />

<property name="net.sf.jasperreports.export.xls.ignore.cell.border" value="false" />

<property name="net.sf.jasperreports.export.xls.ignore.graphics" value="true" />

<property name="net.sf.jasperreports.export.xls.remove.empty.space.between.columns" value="true" />

<property name="net.sf.jasperreports.export.xls.remove.empty.space.between.rows" value="true" />
  

 

HTH

 

Post edited by: lshannon, at: 2008/05/20 14:07

Post edited by: lshannon, at: 2008/05/20 14:09