Multiple tabs in a excel output from BIRT report

vijayshankar245

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

Clement Wong

<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;