Export BIRT report to xlsx format in single page

DeepakKPMG

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

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

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

I have this question as well.

wwilliams

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