Multiple tabs in a excel output from BIRT report
<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>Warning No formatter is installed for the format ipb0 -
<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>
</div>
</blockquote>
<p>Thanks a lot ..</p>0 -
@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!
0 -
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 ipb0 -
@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?
0
Categories
- All Categories
- 108 Developer Announcements
- 53 Articles
- 106 General Questions
- 144 IM Services
- 43 OpenText Hackathon
- 32 Developer Tools
- 20.6K Analytics
- 4.1K AppWorks
- 8.9K Extended ECM
- 899 Cloud Fax and Notifications
- 77 Digital Asset Management
- 9.3K Documentum
- 29 eDOCS
- 120 Exstream
- 39.8K TeamSite
- 1.7K Web Experience Management