dynamically assign name to sheet

Can you use a dynamic label, with some JavaScript to define the label value?

ahsiang

Choose the table, then select script onPageBreak, add in something like this

reportContext.setPageVariable(reportContext.PAGE_VAR_PAGE_LABEL,<Replace here with what you want>)

I used above code,
but no success,its still show "sheet1,sheet2"

<blockquote class='ipsBlockquote' data-author="'vijuagrawa'" data-cid="112911" data-time="1357202453" data-date="03 January 2013 - 01:40 AM">
I used above code, 
but no success,its still show "sheet1,sheet2" </blockquote>
 
Just to clarify: you are trying to have the Excel tabs change from 'sheet1' to 'xyz'; not apply a label to the top of the report?

Yes i am only trying to have the Excel tabs change from 'sheet1' to 'xyz

That solution is outside of my skill set. I would like to see the solution if there is one.

ahsiang

Here's a sample.

http://www.birt-exchange.org/org/devshare/designing-birt-reports/1451-naming-tabs-in-export-to-excel/

<blockquote class='ipsBlockquote' data-author="'ahsiang'" data-cid="112923" data-time="1357224972" data-date="03 January 2013 - 07:56 AM">
Here's a sample. 
 
<a class='bbc_url' href='http://www.birt-exchange.org/org/devshare/designing-birt-reports/1451-naming-tabs-in-export-to-excel/'>http://www.birt-exchange.org/org/devshare/designing-birt-reports/1451-naming-tabs-in-export-to-excel/</a> </blockquote>
Different emitters use different techniques for naming sheets (quoting from that link: "This is only for the commercial version of the Excel emitter."). 
 
Which emitter are you using? 
For the SpudSoft emitters the sheet names come from the name of the table that caused the page break. 
 
Jim

Actually the thing is that i have Group in a table, and pagebreak happen on the basic of group,and i want to rename sheet base on group ,I try adding your code in pagebreak of group but no success

<blockquote class='ipsBlockquote' data-author="'vijuagrawa'" data-cid="113000" data-time="1357535805" data-date="06 January 2013 - 10:16 PM">
Actually the thing is that i have Group in a table, and pagebreak happen on the basic of group,and i want to rename sheet base on group ,I try adding your code in pagebreak of group but no success </blockquote>
 
It really does depend on the emitter you use. 
For the SpudSoft emitters sheets within a group can be set using the table of contents entry for the group. 
 
Jim

<blockquote class='ipsBlockquote' data-author="'Yaytay'" data-cid="113024" data-time="1357583579" data-date="07 January 2013 - 11:32 AM">
It really does depend on the emitter you use. 
For the SpudSoft emitters sheets within a group can be set using the table of contents entry for the group. 
 
Jim </blockquote>
 
What is an emitter and how do you know which one you are using?

<blockquote class='ipsBlockquote' data-author="'Jenkinsj5'" data-cid="113026" data-time="1357583874" data-date="07 January 2013 - 11:37 AM">
What is an emitter and how do you know which one you are using? </blockquote>
Now that's a fair question

Emitters are a type of BIRT plugin. 
Emitters are responsible for taking the processed report structure and converting it to the output format you want. 
So one emitter is responsible for generating Excel format files, another emitter is responsible for generating PDF files. 
 
The built-in Excel emitter in Open Source BIRT leaves a lot to be desired, so there are quite a few alternatives (in fact, if you google "BIRT emitters" the first page is entirely replacement Excel emitters - some free, some not, and some repeated). 
 
If you haven't installed a custom Excel emitter, and noone else has either, then telling us which version of BIRT (including whether it's open source BIRT or an Actuate product) you are using should suffice. 
If you are working with an installation that someone else is in charge of it can be more difficult to tell. 
 
Jim

I am using BIRT 4.2.1

and uk.co.spudsoft.birt.emitters.excel_0.8.0.201211020842

Are you able to post your report design? 
You have a group within a table and you want the sheet names based on the group, yes? 
I'll see if I can knock up an example for you. 
 
Jim

<blockquote class='ipsBlockquote' data-author="'vijuagrawa'" data-cid="113048" data-time="1357624781" data-date="07 January 2013 - 10:59 PM">
I am using BIRT 4.2.1 
 
and uk.co.spudsoft.birt.emitters.excel_0.8.0.201211020842 </blockquote>
Does this help? 
 
The report design has two levels of grouping, but only does page breaks on the higher level (country). 
If you edit the group at that level you can see the following settings: 
 
Page break: 
Before: Auto 
After: Always Excluding Last 
Inside: Avoid 
 
Table of Contents: 
Item Expression: row["COUNTRY"] 
 
It is that table of contents expression that controls the sheet names. 
 
Jim

thanks Jim,

It worked.

rajessu

<blockquote class='ipsBlockquote' data-author="'Yaytay'" data-cid="113050" data-time="1357627634" data-date="07 January 2013 - 11:47 PM">
Does this help? 
 
The report design has two levels of grouping, but only does page breaks on the higher level (country). 
If you edit the group at that level you can see the following settings: 
 
Page break: 
Before: Auto 
After: Always Excluding Last 
Inside: Avoid 
 
Table of Contents: 
Item Expression: row["COUNTRY"] 
 
It is that table of contents expression that controls the sheet names. 
 
Jim </blockquote>
 
 
Hi Jim, 
I too used BIRT 4.2.1, and "uk.co.spudsoft.birt.emitters.excel_0.8.0.201211020842" emitter file and tried running your "rptdesign" file with the same parameters as in your post, yet it is creating only a single sheet for me, i am unable to see multiple sheets as in your attachment. Can you please let me know if it is the correct emitter file or am i missing something? 
 
Thanks, 
Rajesh S