ravikumarg17 Posted August 23, 2012 Share Posted August 23, 2012 Hi,I am exporting jasper report to excel. All the records are exported to one sheet and I have one page header and column header. All this is fine.The only issue I have is I do not get the footer at the bottom of the sheet. I have a sub report which gets displayed at the bottom.I have tried all combinations of following properties net.sf.jasperreports.export.xls.exclude.origin.keep.first.band.1=pageHeadernet.sf.jasperreports.export.xls.exclude.origin.band.2=pageFooternet.sf.jasperreports.export.xls.exclude.origin.keep.first.band.3=columnHeadernet.sf.jasperreports.export.xls.exclude.origin.band.4=columnFooterI get multiple footers when I comment above properties, but I just want one footer at the end of the sheet in report.Please suggest me what property I should be using. Link to comment Share on other sites More sharing options...
jgh Posted August 23, 2012 Share Posted August 23, 2012 I'm not sure if this is what you are looking for, but I have these patches in the FreeBSD port for jasperserver, that you can adopt into your application and try out. It sounds similar to what these accomplished. http://www.freebsd.org/cgi/cvsweb.cgi/ports/databases/jasperserver/files/alt-patch-jasperserver__jasperserver-war__src__main__webappAdditions__WEB-INF__classes__jasperreports.properties?rev=1.1;content-type=text%2Fplainhttp://www.freebsd.org/cgi/cvsweb.cgi/ports/databases/jasperserver/files/alt-patch-jasperserver__common__shared-config__applicationContext.xml?rev=1.1;content-type=text%2Fplain And from the commit log:By default, excel export prints all pages into a single excel sheet.This patch allows to have each page show up as a separate sheet inexcel.Since the default export prints all pages into a single sheet, certainfields are removed: pageHeader, pageFooter, columnHeader, columnFooterThis patch will put one page per sheet, and keep fields intact on each page.[/code] Link to comment Share on other sites More sharing options...
ravikumarg17 Posted August 23, 2012 Author Share Posted August 23, 2012 With above changes I get the data into multiple sheets which I do not want.I am fine with all data recorsds in single sheet, but I want a footer at the bottom which I am not able to get it. 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