Export BIRT report to xlsx format in single page

DeepakKPMG · January 27, 2021

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?

Karen Weir · March 5, 2021

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?

DeepakKPMG · March 5, 2021

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.

wwilliams · March 19, 2021

I have this question as well.

wwilliams · April 8, 2021

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

Export BIRT report to xlsx format in single page

Comments

Categories