Export BIRT report to xlsx format in single page
We have deployed BIRT report in IBM Tririga application and enable option to export BIRT report to xlsx. We set pageBreakInterval=0 to avoid pagination. But Each page is taking 10000 records per page. When we export BIRT report to xls, it works fine but for xlsx format, after 10000 records next records appear on new sheet. We want all records in single page in xlsx format. Can anyone able to provide help how to achieve this?
Comments
-
Hi @DeepakKPMG , I see that your post does not yet have replies from the community members - have you resolved this, or is it still open for discussion?
0 -
Thanks Karen for addressing this issue, but this requirement was cancelled for now and also I don't find any solution. So just from knowledge point if I can get reply then it will be good to implement solution in future.
0 -
One solution, it works from Maximo.
In the beforeFactory
reportContext.getAppContext().put("MAX_PAGE_BREAK_INTERVAL",1000000);
Then in the header
if(reportContext.getOutputFormat()=="xlsx"{
if(pageNumber>1) {
this.getStyle().display="none";
}
For the Page Break page break interval: enter 1000000
0
Categories
- All Categories
- 118 Developer Announcements
- 52 Articles
- 150 General Questions
- 137 Services
- 56 OpenText Hackathon
- 35 Developer Tools
- 20.6K Analytics
- 4.2K AppWorks
- 9K Extended ECM
- 912 Cloud Fax and Notifications
- 82 Digital Asset Management
- 9.3K Documentum
- 30 eDOCS
- 175 Exstream
- 39.8K TeamSite
- 1.7K Web Experience Management
- 6 XM Fax