Page Break not working with MDX

0

I'm facing Page break issue with my report.
I migrated report from SQL to MDX and Cube. Page break and one page per sheet property for excel was working fine in SQL report but after migration to MDX it stopped working and all 3 pages coming on single pages and hence excel functionality is also not working.

Then i came to know about property called as net.sf.jasperreports.page.break.no.pagination, i set 'apply' value to this property and now i get following error :

net.sf.jasperreports.engine.JRRuntimeException: Out of range start value -2147483305

at net.sf.jasperreports.engine.export.tabulator.DimensionEntries.getRange(DimensionEntries.java:75)

at net.sf.jasperreports.engine.export.tabulator.Tabulator.placeElement(Tabulator.java:143)

at net.sf.jasperreports.engine.export.tabulator.Tabulator.layoutElements(Tabulator.java:133)

at net.sf.jasperreports.engine.export.tabulator.Tabulator.tabulate(Tabulator.java:84)

at net.sf.jasperreports.engine.export.HtmlExporter.exportPage(HtmlExporter.java:641)

at net.sf.jasperreports.engine.export.HtmlExporter.exportReportToWriter(HtmlExporter.java:601)

at net.sf.jasperreports.engine.export.HtmlExporter.exportReport(HtmlExporter.java:397)
 

Full Error in attached file.

 

I'm using ireport designer 4.8 and Jasper Server 5.2 community version.

Please help me out.

Thanks in advance. :)

 

P.S :

Ignore Pagination -  True

Page breaks in the report 

net.sf.jasperreports.export.xls.one.page.per.sheet - true

 

 

Attachments: 
rohit.shinde9690's picture
Joined: Jan 21 2013 - 3:28am
Last seen: 4 years 3 months ago

I'm getting the same issue here. Did you ever resolve this?

cameron_1 - 5 years 8 months ago

Answered below

rohit.shinde9690 - 5 years 8 months ago

2 Answers:

0

This may not fix your problem, but you should be using the same version of iReport as JasperServer. Can you also test if this happens with the latest release of iReport and JasperServer?

 

hozawa's picture
54540
Joined: Apr 24 2010 - 4:31pm
Last seen: 6 months 5 days ago

I tried on Jasper Server 5.5 still it is not working... :(

rohit.shinde9690 - 5 years 9 months ago
0

Fixed this issue by following method:

Changed com.jaspersoft.jasperreports.export.html.type to html in …\WEB-INF\classes\jasperreports.properties file
Take a look at following link in section 

Enabling the XHTML or HTML Exporters

http://community.jaspersoft.com/documentation/jasperreports-server-admin...

rohit.shinde9690's picture
Joined: Jan 21 2013 - 3:28am
Last seen: 4 years 3 months ago
Feedback
randomness