Naming tabs in Export to Excel

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

  • BIRTdevoteeBIRTdevotee BIRTdevotee

    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.