Sunday, February 19, 2012

Exporting to Excel Problems (URL Access)

Hello,
I'm using SQL Server 2005 Reporting Services. I'm having an issues when
exporting to Excel. I'm using URL Access to generate the report and display
it in a browser window. I then choose Excel and click the Export link.
Doing this opens a temporary browser window and then a dialog that asks if I
want to save the report or open it. If I choose to open it, the report
opens in Excel without problem. The problem is that the temporary browser
window doesn't go away (close) automatically like it should. What makes
this a little more strange is that this behavior only seem to occur on a
Windows XP computer. If I run the report from a Windows 2000 or Windows
Server 2003 computer, the temporary browser windows closes automatically
(and the report is exported to Excel and opened).
Has anyone experienced this same issue?
Does anyone know how to "fix" this issue so that exporting to open right
away always closes the temporary browser window?
Thanks.I am currently experiencing the same issue on Server 2003. The blank window
remains. I was unaware that it closes on other systems. Have you found the
solution?
"steggun" wrote:
> Hello,
> I'm using SQL Server 2005 Reporting Services. I'm having an issues when
> exporting to Excel. I'm using URL Access to generate the report and display
> it in a browser window. I then choose Excel and click the Export link.
> Doing this opens a temporary browser window and then a dialog that asks if I
> want to save the report or open it. If I choose to open it, the report
> opens in Excel without problem. The problem is that the temporary browser
> window doesn't go away (close) automatically like it should. What makes
> this a little more strange is that this behavior only seem to occur on a
> Windows XP computer. If I run the report from a Windows 2000 or Windows
> Server 2003 computer, the temporary browser windows closes automatically
> (and the report is exported to Excel and opened).
> Has anyone experienced this same issue?
> Does anyone know how to "fix" this issue so that exporting to open right
> away always closes the temporary browser window?
> Thanks.
>
>

No comments:

Post a Comment