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've noticed that issue without using URL access. My users love exporting to Excel, and it bugs me when I test exporting, and have windows open all over the place. I'd like to know what the fix is as well. I imagine it is just an IE thing, and there's nothing we can do about it.|||

Did you fine an answer for this one. I am experiencing the same issue.

Thanks for help in advance.

Mehul

No comments:

Post a Comment