Multiple tabs in a excel output from BIRT report

Hi


 


I have a report with three different straight tables. I want all the three in 3 different tabs while generating the report as xlsx. 


 


is it possible to create the three tables in 3 different tabs in a report? I tried it with dashboard but Im not able to export all the contents in a single excel file.


 


Please help if anyone have encountered the same issue. I'm using Actuate 4.4.0 version.


Comments

  • I have a report with three different straight tables.


     


    What does this mean exactly?  Three tables that are sequential, one on top of each other, in a column?  Or you have three tables in parallel?


     


    I want all the three in 3 different tabs while generating the report as xlsx.  is it possible to create the three tables in 3 different tabs in a report


     


    You can select the option "Output to multiple sheets" when exporting to Excel, and in your design, you'll need to add a line in the onPageBreak of your tables or grids to name your Excel tab when it page breaks:


     


    reportContext.setPageVariable( reportContext.PAGE_VAR_PAGE_LABEL, "Summary");


     


    Or you can use dynamic values:


    reportContext.setPageVariable( reportContext.PAGE_VAR_PAGE_LABEL, this.getValue() );


     



    This DevShare has more details @ http://developer.actuate.com/community/forum/index.php?/files/file/812-naming-tabs-in-export-to-excel/

    Clement Wong
    Principal Analytics Architect

    OpenText Corporation
    http://www.actuate.com | http://www.opentext.com



  • I have a report with three different straight tables.


     


    What does this mean exactly?  Three tables that are sequential, one on top of each other, in a column?  Or you have three tables in parallel?


     


    I want all the three in 3 different tabs while generating the report as xlsx.  is it possible to create the three tables in 3 different tabs in a report


     


    You can select the option "Output to multiple sheets" when exporting to Excel, and in your design, you'll need to add a line in the onPageBreak of your tables or grids to name your Excel tab when it page breaks:


     


    reportContext.setPageVariable( reportContext.PAGE_VAR_PAGE_LABEL, "Summary");


     


    Or you can use dynamic values:


    reportContext.setPageVariable( reportContext.PAGE_VAR_PAGE_LABEL, this.getValue() );


     


    This DevShare has more details @ http://developer.actuate.com/community/forum/index.php?/files/file/812-naming-tabs-in-export-to-excel/




    Thanks a lot ..

  • @Clement Wong said:
    I have a report with three different straight tables.

     

    What does this mean exactly?  Three tables that are sequential, one on top of each other, in a column?  Or you have three tables in parallel?

     

    I want all the three in 3 different tabs while generating the report as xlsx.  is it possible to create the three tables in 3 different tabs in a report

     

    You can select the option "Output to multiple sheets" when exporting to Excel, and in your design, you'll need to add a line in the onPageBreak of your tables or grids to name your Excel tab when it page breaks:

     

    reportContext.setPageVariable( reportContext.PAGE_VAR_PAGE_LABEL, "Summary");

     

    Or you can use dynamic values:

    reportContext.setPageVariable( reportContext.PAGE_VAR_PAGE_LABEL, this.getValue() );

     


    This DevShare has more details @ http://developer.actuate.com/community/forum/index.php?/files/file/812-naming-tabs-in-export-to-excel/

    I am using the BIRT 4.4.1 and setup the page name at the table onPageBreak script as below:
    reportContext.setPageVariable( reportContext.PAGE_VAR_PAGE_LABEL, row[groupName] );

    But it did not work for me. Please let me know what is missing? thanks!

  • As per the DevShare (https://communities.opentext.com/forums/discussion/61218/naming-tabs-in-export-to-excel), it is only available on the commercial BIRT version.

    Clement Wong
    Principal Analytics Architect

    OpenText Corporation
    http://www.actuate.com | http://www.opentext.com

  • @Clement Wong said:
    As per the DevShare (https://communities.opentext.com/forums/discussion/61218/naming-tabs-in-export-to-excel), it is only available on the commercial BIRT version.

    thanks a lot for your response! Is there a way to make it work in the open source version?

Sign In or Register to comment.