Multiple tabs in a excel output from BIRT report

vijayshankar245
edited February 11, 2022 in Analytics #1
<p>Hi</p>
<p> </p>
<p>I have a report with three different straight tables. I want all the three in 3 different tabs while generating the report as xlsx. </p>
<p> </p>
<p>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.</p>
<p> </p>
<p>Please help if anyone have encountered the same issue. I'm using Actuate 4.4.0 version.</p>

Comments

  • <p><em>I have a report with three different straight tables.</em></p>
    <p> </p>
    <p>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?</p>
    <p> </p>
    <p><em>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</em></p>
    <p> </p>
    <p>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:</p>
    <p> </p>
    <p>reportContext.setPageVariable( reportContext.PAGE_VAR_PAGE_LABEL, "Summary");</p>
    <p> </p>
    <p>Or you can use dynamic values:</p>
    <p>reportContext.setPageVariable( reportContext.PAGE_VAR_PAGE_LABEL, this.getValue() );</p>
    <p> </p>
    <p>
    This DevShare has more details @ <a data-ipb='nomediaparse' href='http://developer.actuate.com/community/forum/index.php?/files/file/812-naming-tabs-in-export-to-excel/'>http://developer.actuate.com/community/forum/index.php?/files/file/812-naming-tabs-in-export-to-excel/</a></p&gt;
    Warning No formatter is installed for the format ipb
  • <blockquote class="ipsBlockquote" data-author="Clement Wong" data-cid="142969" data-time="1458692370">
    <div>
    <p><em>I have a report with three different straight tables.</em></p>
    <p> </p>
    <p>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?</p>
    <p> </p>
    <p><em>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</em></p>
    <p> </p>
    <p>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:</p>
    <p> </p>
    <p>reportContext.setPageVariable( reportContext.PAGE_VAR_PAGE_LABEL, "Summary");</p>
    <p> </p>
    <p>Or you can use dynamic values:</p>
    <p>reportContext.setPageVariable( reportContext.PAGE_VAR_PAGE_LABEL, this.getValue() );</p>
    <p> </p>
    <p>This DevShare has more details @ <a data-ipb='nomediaparse' href='http://developer.actuate.com/community/forum/index.php?/files/file/812-naming-tabs-in-export-to-excel/'>http://developer.actuate.com/community/forum/index.php?/files/file/812-naming-tabs-in-export-to-excel/</a></p&gt;
    </div>
    </blockquote>
    <p>Thanks a lot ..</p>
  • @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.

    Warning No formatter is installed for the format ipb
  • @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?