all groups > sql server reporting services > september 2004 >
You're in the

sql server reporting services

group:

export to excel, file not found


export to excel, file not found JeffW
9/4/2004 6:39:08 AM
sql server reporting services:
With sp1 installed, when a user exports a chart to excel via url
(ReportServerUrl/MyReport&rs:Command=Render&rs:Format=EXCEL ... I set this up
as a link on the report) everything works when the user has office xp
installed, but with office 2000, the user can only use the save as feature,
and then open the excel rendered chart. If the user selects "open" from the
dialog prompt, they get an error:

C:\Documents and Settings\User\Local Settings\Temporary Internet
Files\Content.IE5\KJYHDDL\Chart[1].xls Could not be found. Check the
spelling of the name ...

Is this the result of a browser setting, or server security on my end?

Re: export to excel, file not found Brian Welcker [MSFT]
9/5/2004 1:49:09 PM
Have you installed Reporting Services SP1 on the server? This is required
for Office 2000 support.

--
Brian Welcker
Group Program Manager
SQL Server Reporting Services

This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]

Re: export to excel, file not found JeffW
9/5/2004 4:39:02 PM
Brian,
Thanks for your reply.

I have installed sp1 on the server, and verified that both my dev
environment and server are running version 8.00.878.00. Also, the excel
export does work, when the user chooses to save the file and then open it
(office 2000). It only fails when they try to open the exported chart
directly from the dialog that says "You are downloading the file ... Would
you like to open the file or save it to your computer ...". And it only
happens when to office 2000 or less users.

After installing sp1 on the server, I did not reboot or anything, but
confirmed that the version matched my dev environment that also has sp1.
Should I create the report from scratch or are there files/timestamps I
should be looking for on the server related to the renderer/exporter?

Thanks,
JeffW

[quoted text, click to view]
AddThis Social Bookmark Button