issue download report to excel, is it a BO bug?

[Former Member]

Hi,

I have a report named "Forecast Availability Report", I want to download it to excle file.

I click "Document-> save to my computer as-> Excel" , and a pop-up shows, and it says "Do you want to open or save this file

Name: Forecast_availability_Report.xls

Type: Microsoft Excel worksheet

"

I know the Excle file name will set as the report title by default.

But after I changed my language of IE explorer option to Japanese, and I download again, the default Excel file name is not correct, it change to "Forecast_Av.xls" .Another example ,report title is "Employee Hours and Revenue by Week ", the excel file

name is "Employee_Ho.xls". It seems that if IE language is Japanese, then the Excle file name is truncated, and only can display 10 chars.

Could you please tell me how to resolve this issue?

thanks in advance!

Regards,

Tony

[former_member142702 · Accepted solution]

Hi,

which kind of report is this? (CR, WebI, Deski) Which verison of BOBJ (incl. Service Packs and Fix Packs) do you use?

Regards,

Stratos

[Former Member · Accepted solution]

Hi ,

It is Webi Report

my BO server infomation

nvironment information of the BO server.

****************************************

Product

****************************************

Product Name

[BusinessObjects XI Release 2]

Product Version

[XI R2]

Applied patch

[ Production Pack]

==============================

Server environment

iBusinessObjects Enterprise etcj

==============================

OS and OS Version

[Windows Server 2003 R2 Standard Edition Service Pack 2 ]

Single unit or Multiple unit

[2 unit ]

==============================

Web & Application Server

==============================

Web & Application Server

[Tomcat]

Product Version

[Tomcat 5.0.27]

.NET Runtime or JVM Version

[j2sdk1.4.2_08 ]

==============================

Repository data base

==============================

Product

[Mysql ]

Product Version

[ 4.1.13a]

Middleware version

[ ]

[former_member142702 · Accepted solution]

Hi

there is a related correction in Service Pack 4. It is not exactly the truncating problem, but only solutions for problems which are reported from external customers are documented. I think it may be worth it to try this.

ADAPT00823802

Description:

When a Web Intelligence report is saved as PDF or Excel from the HTML View mode in InfoView, a space in the file name is

replaced by an underscore.

New Behavior:

This problem is resolved.

Spaces now remain in the file name.

Regards,

Stratos

[former_member142702 · Accepted solution]

I would even recommend to update to the latest Service Pack (5) and fix pack (5.5) in your case. If the problem persists after that then it surely is a bug and has to be reported to SAP support.

Regards,

Stratos

[Former Member · Accepted solution]

Hi Efstratios ,

thank you, I will update the service pack and have a try, I will get back to you, thank you for you help.

Best Regards,

Tony

[Former Member · Accepted solution]

Hello Stratos,

I get the reply from SAP

==================================================================================================

In the case the locale of interface is Japanese,title is more than 12 charaters, WEBI document saving to Excel file, in the file download box, only display the first 11 characters,this is the limitation of XI R2 product. You can add character after the file name, or you can use a short file name.

I can't upgrade my BO. I use boxir2win_sp4_inc.exe,but it fails...

[Former Member]

Hi Tony,

IE 9  and WEBi Rich client, the report name is working fine. Could you please let me know which browser you are using?

Thanks,

Jesudas

[Former Member]

I am also having the same issue in BI4.1 SP05 and FP 05.

Thanks,

Jesudas