escalhao3 Posted September 22, 2014 Share Posted September 22, 2014 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 Link to comment Share on other sites More sharing options...
darth_fader Posted September 22, 2014 Share Posted September 22, 2014 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.htmlAlso, 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? Link to comment Share on other sites More sharing options...
honeybakliwal Posted September 23, 2014 Share Posted September 23, 2014 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.ThanksHoney Link to comment Share on other sites More sharing options...
jaspersoft123 Posted September 24, 2014 Share Posted September 24, 2014 Add this property in your XML code.<property name="net.sf.jasperreports.export.xls.show.gridlines" value="true"/> 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