Maximo

Maximo

Come for answers, stay for best practices. All we're missing is you.

 View Only

  • 1.  BIRT report xlsx breaking pages for a table want to have data for that table in one tab

    Posted Mon October 21, 2024 08:53 PM

    BIRT report xlsx breaking pages for a table want to have data for that table in one tab 

    Tried setting page break properties before ,after ,inside auto and page break interval to 0 did not work 



  • 2.  RE: BIRT report xlsx breaking pages for a table want to have data for that table in one tab

    Posted Tue October 22, 2024 12:58 AM

    Hi Karishma,

    I believe this is out-of-the-box and working as designed. Try exporting to .xls instead.



    ------------------------------
    If this post helps, please consider accepting it as a solution to help other members find it more quickly.

    Maycon Belfort
    Consultant
    BPD Zenith
    Melbourne
    ------------------------------

    Original Message


  • 3.  RE: BIRT report xlsx breaking pages for a table want to have data for that table in one tab

    Posted Tue October 22, 2024 04:09 AM
    1. Set Layout Prefrence to Fixed
    2. Set Page break for table to 999999
    3. Change the heght of master page to 99999


    ------------------------------
    Andrey Ilinskiy
    Handz.on
    https://www.on.de/
    München
    ------------------------------

    Original Message


  • 4.  RE: BIRT report xlsx breaking pages for a table want to have data for that table in one tab

    Posted Wed October 23, 2024 04:34 AM

    Hi Karishma,

    Hope all is great.  xlsx output can be a bit painful.  

    I use this script in the beforeFactory event of the report and set the page break on the table to match 

    reportContext.getAppContext().put("MAX_PAGE_BREAK_INTERVAL",1000000);

    if(reportContext.getOutputFormat()=="xlsx")

    {

          if(pageNumber >1 )      

          {

          this.getStyle().display="none";

          }    

    }

    I hope this helps

    Daz



    ------------------------------
    Darren Hornidge
    Asset Care Systems Manager
    CCEP
    Melbourne VIC
    ------------------------------

    Original Message


  • 5.  RE: BIRT report xlsx breaking pages for a table want to have data for that table in one tab

    Posted Thu January 30, 2025 10:08 AM

    A little late seeing this @Darren Hornidge, but thank you for sharing this code! This is going to make a number of our users who are stuck on XLSX format VERY happy.



    ------------------------------
    Jason Verly
    Director of Reliability Engineering
    Agropur US
    ------------------------------

    Original Message


  • 6.  RE: BIRT report xlsx breaking pages for a table want to have data for that table in one tab

    Posted Tue February 04, 2025 04:00 AM

    Hi Jason,

    Oh that is cool. Glad people will get the benefit.  

    Cheers

    Daz



    ------------------------------
    Darren Hornidge
    Asset Care Systems Manager
    CCEP
    Melbourne VIC
    ------------------------------

    Original Message


Related Content