Exporting my Report to Excel

0

Hi everyone!

I've benn trying to save my report to excel but when I do the layout gets all messy and some things that are displayed in the ReportViewer just isn't in the excel file, for exemple, some frames...

I'll post both images so you can see what I'm talking about. The first one is the  report on the ReportViewer and the second one is on the Excel file.

 

So far, so good...

I don't know if this happens because of the layout or I didn't configure something (or did it wrong). 

I hope you can help me!

Regards,

Felipe

escalhao3's picture
Joined: Apr 2 2014 - 9:29am
Last seen: 3 years 10 months ago

3 Answers:

0

Try  net.sf.jasperreports.export.xls.remove.empty.space.between.columns ; this will clean up some of the mess. Refer here for more details, that and google will get you through: http://jasperreports.sourceforge.net/config.reference.html

Also, you need to line up your column witdths in the jrxml as much as possible. See how you've got different widths between POD summary and VESSEL summary? 

darth_fader's picture
Joined: Mar 7 2010 - 9:45pm
Last seen: 1 week 18 hours ago
0

Hi 

 

There is nothing wrong with your excel output just you need to take care of little bit of formatting. Just try to make the size of all the columns so that the overlapping is no more there.

Thanks

Honey

honeybakliwal's picture
Joined: Sep 8 2010 - 2:37am
Last seen: 1 year 2 months ago
0

Add this property in your XML code.

<property name="net.sf.jasperreports.export.xls.show.gridlines" value="true"/>

jaspersoft123's picture
Joined: Sep 24 2014 - 12:15am
Last seen: 1 year 2 months ago
Feedback
randomness