Specify EXCEL file name and Sheet name in Actuate 10

Hi,

We have a requirement to generate EXCEL report while clicking the link in the application. We are using Actuate 10 to generate EXCEL report. We are trying to deploy .rptdesign file in iServer and access the EXCEL file by specifying file type.

I am getting difficulty to specifying EXCEL file name and also EXCEL sheet name. By default file is generating with 'iv.xls'. Please help me how to specify excel file name and sheet name

There is a solution in this forum, but it is not working for me. It is giving unhandled exception.Please tell me how can I use it or any other solutions are appreciated.

http://www.birt-exchange.org/org/forum/index.php/topic/20900-excel-output-in-multiple-sheets/page__s__3e01094c8ec0f8571be0c13e055ffd75

'Use in OnPageBreak
reportContext.setPageVariable( reportContext.PAGE_VAR_PAGE_LABEL, this.getValue() ); '

Thanks in advance

Find more posts tagged with

Comments

thuston

That solution for naming Sheets only works in Actuate 11 (BIRT 2.6).

The iServer can properly name the output file if you select the type when initially running.
iv.xls sounds like you are already viewing in Interactive Viewer and tried to Export to XLS.
In this case you are either viewing and the XLS is not saved anywhere or you were presented with a Save As dialog.

I think there may be a workaround to the file being named iv.(type) instead of defaulting to the source filename. You'd have to check with support@actuate.com. If there is no workaround, they can tell you if there is an Enhancement filed.

tpvlaxmi

Thanks thuston for you reply. 
 
Yes, you are right. After designing the document and I am running the report as XLS. I will try to specify type at iServer. Could you tell me how to configure at iServer for specifying EXCEL file name. 
 
From your reply Actuate does not support changing EXCEL sheet name. Is it possible for creating multiple sheets in Excel? Please tell how can I do that. 
 
Thanks in advance 
Laxmi 
 
<blockquote class='ipsBlockquote' data-author="'thuston'" data-cid="71050" data-time="1291655177" data-date="06 December 2010 - 10:06 AM">
That solution for naming Sheets only works in Actuate 11 (BIRT 2.6). 
 
The iServer can properly name the output file if you select the type when initially running. 
iv.xls sounds like you are already viewing in Interactive Viewer and tried to Export to XLS. 
In this case you are either viewing and the XLS is not saved anywhere or you were presented with a Save As dialog. 
 
I think there may be a workaround to the file being named iv.(type) instead of defaulting to the source filename. You'd have to check with support@actuate.com. If there is no workaround, they can tell you if there is an Enhancement filed. </blockquote>