Welcome and thank you for joining our new OpenText forum. Your questions, responses, best practices, and tips shared with other members will help make this channel vibrant. We're glad you're joining us and look forward to collaborating with you online.

Check out the Getting Started With OpenText Forums for tips on personalizing your experience.

Naming tabs in Export to Excel

edited July 11, 2013 in DevShare Downloads
First, thanks to Trevor Huston for pointing the way. In the attached zip file are two examples. One uses hard coded value to name the tabs, while the other uses values from the database. Both examples use Classic Models sample database. This is only for the commercial version of the Excel emitter. To test run the reports and export to XLS or XLSX. Make you check the box 'Output to multiple sheets'. The code is simple and is on the 'onPageBreak' event.



For hard coded value:
reportContext.setPageVariable( reportContext.PAGE_VAR_PAGE_LABEL, "Table" );


For value based on data (on the report item in group header):
reportContext.setPageVariable( reportContext.PAGE_VAR_PAGE_LABEL, this.getValue() );

Comments

  • Hi Mica ,

    will this work in eclipse BIRT version free version ?

  • I believe it should work. If it doesn't, it's my understanding that OS Birt also picks up the name of things like tables and grids (and possibly other elements).

    Chad Montgomery
    Customer Support Engineer | Customer Support
    OpenText Corporation
Sign In or Register to comment.