Cannot export to excel from report manager

I'm reposting this since no one has answered and I'm finding other forums
where people are asking the same question and no answers to be found,
including when I asked the question. It seems like if I'm not the only
person seeing this error, someone, somewhere should have it documented.
I have a windows server 2003 box running in production with SQL Reporting
services, not sure of the version.
When attempting to export to Excel from report manager we get the error:
"Internet Explorer cannot download Format=Excel from reports.server
Internet Explorer was not able to open this Internet site. The requested
site is either unavailable or cannot be found. Please try again later."
We only get this error on some machines. Other machines work just fine.
They are all running against the production server. We do not get the error
when it's run against the dev server.I've run into problems with Excel export with two different scenarios:
- some of the controls in the report did not have the same language setting
as the report
- I'd used special Norwegian characters (like æøå)
I don't think the second scenario applies to you. :) But you might want to
make sure all the controls are in the same language. Just a stab in the
dark: Do you use User!Language for any reports or controls? In that case the
reports might work out on computers with the same language setting as the
server, but not if you run a different language.
Do the computers with errors have the same security settings in the browser
as the ones without error?
Kaisa M. Lindahl Lervik
"Valleri_Collins" <ValleriCollins@.discussions.microsoft.com> wrote in
message news:3FF0AABE-DE24-4941-B5C2-D7AE390391FE@.microsoft.com...
> I'm reposting this since no one has answered and I'm finding other forums
> where people are asking the same question and no answers to be found,
> including when I asked the question. It seems like if I'm not the only
> person seeing this error, someone, somewhere should have it documented.
> I have a windows server 2003 box running in production with SQL Reporting
> services, not sure of the version.
> When attempting to export to Excel from report manager we get the error:
> "Internet Explorer cannot download Format=Excel from reports.server
> Internet Explorer was not able to open this Internet site. The requested
> site is either unavailable or cannot be found. Please try again later."
> We only get this error on some machines. Other machines work just fine.
> They are all running against the production server. We do not get the
> error
> when it's run against the dev server.
>|||Between the two computers we've been working with, they are identical except
for one is running Windows 2K SP4 and the other is Win XP SP 2. All the
other settings are the same. The other thing we've found is that on a
different XP machine using the same image as the one we have the problem on,
if the user is given local admin rights the problem doesn't occur. However,
granting local admin rights to the user experiencing the issue did not
resolve the issue on her machine.
"Kaisa M. Lindahl Lervik" wrote:
> I've run into problems with Excel export with two different scenarios:
> - some of the controls in the report did not have the same language setting
> as the report
> - I'd used special Norwegian characters (like æøå)
> I don't think the second scenario applies to you. :) But you might want to
> make sure all the controls are in the same language. Just a stab in the
> dark: Do you use User!Language for any reports or controls? In that case the
> reports might work out on computers with the same language setting as the
> server, but not if you run a different language.
> Do the computers with errors have the same security settings in the browser
> as the ones without error?
> Kaisa M. Lindahl Lervik
> "Valleri_Collins" <ValleriCollins@.discussions.microsoft.com> wrote in
> message news:3FF0AABE-DE24-4941-B5C2-D7AE390391FE@.microsoft.com...
> > I'm reposting this since no one has answered and I'm finding other forums
> > where people are asking the same question and no answers to be found,
> > including when I asked the question. It seems like if I'm not the only
> > person seeing this error, someone, somewhere should have it documented.
> >
> > I have a windows server 2003 box running in production with SQL Reporting
> > services, not sure of the version.
> > When attempting to export to Excel from report manager we get the error:
> > "Internet Explorer cannot download Format=Excel from reports.server
> >
> > Internet Explorer was not able to open this Internet site. The requested
> > site is either unavailable or cannot be found. Please try again later."
> >
> > We only get this error on some machines. Other machines work just fine.
> > They are all running against the production server. We do not get the
> > error
> > when it's run against the dev server.
> >
>
>