Export BIRT report to xlsx format in single page

DeepakKPMG
edited February 11, 2022 in Analytics #1

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

  • Karen Weir
    Karen Weir E Community Administrator

    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?

  • 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.

  • I have this question as well.

  • 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