Page break not working in excel export in jasper server output.

Hi,

 

I want data from two table on two diffrent sheets. I inserted page break after table and I am getting data in different sheets in excel export tin Jaspersoft studio. However it's not working in jasper server excel export output where I am getting data on single sheet only.

amrutaa's picture
229
Joined: May 21 2015 - 11:25pm
Last seen: 7 years 1 month ago

2 Answers:

Did you set the properties to create different sheets?

net.sf.jasperreports.export.xls.one.page.per.sheet="true"

hozawa's picture
177939
Joined: Apr 24 2010 - 4:31pm
Last seen: 3 years 12 months ago

Yes it was checked that property. After setting the property as "net.sf.jasperreports.page.break.no.pagination"=apply at report level  the multi sheets functionality works.

Thanks.

amrutaa's picture
229
Joined: May 21 2015 - 11:25pm
Last seen: 7 years 1 month ago
Feedback
randomness