Jaspersoft server excel export cell height increases

0

 

I've designed the report in Jaspersoft (5.6.1). When I upload it to server and export to excel, the cell height changes according to the next cell item.

Assume there is text field of height 0.20 inches and next to it is a Chart of Height 5.20 Inches. When I export this design from studio, it works fine. But when I export to excel from JasperServer, the Text field cell height increases according to height of Chart.

I'm sure I kept each field's position type to Fix realtive to Top and Strech type to No strech.

Is there any special settings to be done on Server side too?

FYI, I followed all tips for Excel export

Thanks

Sreeram

sreerambabu.palaniswamy's picture
Joined: Jun 11 2015 - 9:25pm
Last seen: 2 years 9 months ago

3 Answers:

0

5.6.1 still had some bugs and is no longer supported. Recommend that you try with newer version to find if the problem has been corrected or not.

hozawa's picture
72632
Joined: Apr 24 2010 - 4:31pm
Last seen: 2 years 1 month ago
0

Since the report is exporting properly in JSS, make sure your jasperreports.properties match between Jaspersoft Studio (Properties -> Jaspersoft Studio -> Properies ) and Jasper Reports Server (/webapps/jasperserver-pro/WEB-INF/classes/jasperreports.properties)

Watch specially the net.sf.jasperreports.export.xls.* ones.

marianol's picture
5828
Joined: Sep 13 2011 - 8:04am
Last seen: 2 years 9 months ago
0

Hi Maria,

When I open the Design file in JSS, the default properties shows the "Configure workspace setting".In the workspace settings, I don't see the Excel export features. Also there is an option for Use Project settings, but this option is not selected by default. However all export settings are done at the project level.

 

As I couldn't change the deafult use setting to Project for JSS, I've added the following properties to JSS under Workspace settings.

 

net.sf.jasperreports.export.xls.one.page.per.sheet=true
net.sf.jasperreports.export.xls.remove.empty.space.between.rows=false
net.sf.jasperreports.export.xls.remove.empty.space.between.columns=false
net.sf.jasperreports.export.xls.white.page.background=true
net.sf.jasperreports.export.xls.detect.cell.type=true
net.sf.jasperreports.export.xls.ignore.graphics=false
net.sf.jasperreports.export.xls.create.custom.palette=true
net.sf.jasperreports.export.xls.font.size.fix.enabled=false
net.sf.jasperreports.export.xls.ignore.cell.background=false
net.sf.jasperreports.export.xls.ignore.cell.border=false
 
I appened the same in /webapps/jasperserver-pro/WEB-INF/classes/jasperreports.properties and restarted the services. But still the issue persists when I export to excel.
 
e
 
Please see the difference how it exports to excel from server and from JSS respectively. It happens not only with Chart. It happens even with the text field which are adjacent and the height is different.Please do advise
 
Thanks
 
sreeram
 
 
 
 

 

sreerambabu.palaniswamy's picture
Joined: Jun 11 2015 - 9:25pm
Last seen: 2 years 9 months ago
Feedback
randomness