Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 SSRS issue, need help...very urgent

Author  Topic 

Ramu.valleti
Starting Member

3 Posts

Posted - 2009-06-22 : 23:52:01
Hello There,

We have an issue here, looks like a limitation of IE 6. If someone has faced this and found a solution, please let us know.

We are using SQL server 2005(SP2). And the client machine has Windows XP(sp2) and IE6.

When the user tries to export a report in SSRS, a browser window opens up along with the "Open/Save" dialog box . And when the report is saved or opened in the chosen format, the browser window closes automatically. This happens in the server (Windows Server 2003 with IE 6). But with Windows XP and IE 6, the browser window remains open and has to be manually closed. Is there a way to close this automatically?

Please suggest any solution or workaround ASAP.

Ramu
No Dream Is Too Big....!

kmarshba
Starting Member

24 Posts

Posted - 2009-06-23 : 11:26:34
Hey Ramu,

You'll need to provide some more detail to help us provide an answer. Is the user directly in the SSRS interface, or are you providing a custom UI and rendering the report via code or the Report Viewer?

Without any additional information I would presume it's an issue with browser specific scripting (although you indicate this isn't the case) or possibly a browser setting disabling the closing of the browser. Reminder, for the script to be able to close a browser without a prompt it has to have generated the browser window via script (a child window), otherwise the user will be prompted.

It's been a while since I've messed with generating additional browser windows (best practice is to avoid doing this) so my understanding could be dated.

Regardless, provide more info for a better answer :-\
Go to Top of Page

Ramu.valleti
Starting Member

3 Posts

Posted - 2009-06-23 : 12:44:26
Hi,

Thanks for your immediate responce.

I'm using MOSS 2007 as interface.

I've checked and tried all the options available in the browser. And with the same settings, the additional blank window closes automatically in IE7 but not in IE6(windows serevr 2003+IE6, the blank window closes automatically).

Is this an issue with Windows XP+IE6?


Ramu



Ramu
No Dream Is Too Big....!
Go to Top of Page

kmarshba
Starting Member

24 Posts

Posted - 2009-06-23 : 13:05:54
Ah, well, MOSS is out of my area of expertise.

I would presume it is a MOSS 2007 issue with XP + IE6. I would start searching on MOSS 2007 & IE6 issues related to the browser not closing. Focus on MOSS 2007 being the issue versus IE6 as it's MOSS code doing the work.

That'd be my first pass at finding a resolution. Hopefully someone else on here has MOSS experience??? But you're probably going to want to find a MOSS forum for this question.

Kevin
Go to Top of Page

gedwards
Starting Member

19 Posts

Posted - 2009-06-23 : 16:10:55
I have a Reporting Services report exposed in our PerformancePoint server. When I go to Export to Excel, after I click Save in the dialog box, the dialog box disappears.
I have IE 7 on my client machine. And PerformancePoint is running SP1 right now. So if I read you right, my client acts like your server, which is what you want?
You might try running this by the PerformancePoint Team

http://blogs.msdn.com/performancepoint/default.aspx
Greg E

Greg E
Go to Top of Page

Ramu.valleti
Starting Member

3 Posts

Posted - 2009-06-24 : 00:27:13
quote:
Originally posted by kmarshba

Ah, well, MOSS is out of my area of expertise.

I would presume it is a MOSS 2007 issue with XP + IE6. I would start searching on MOSS 2007 & IE6 issues related to the browser not closing. Focus on MOSS 2007 being the issue versus IE6 as it's MOSS code doing the work.

That'd be my first pass at finding a resolution. Hopefully someone else on here has MOSS experience??? But you're probably going to want to find a MOSS forum for this question.

Kevin



This is not a MOSS 2007 issue, as i did the same exporting in report manager and reporserver and the blank window is still not closing automatically.

So, i believe there is a problem with SSRS 2005 and IE6 in WindowsXP.




Ramu
No Dream Is Too Big....!
Go to Top of Page

gedwards
Starting Member

19 Posts

Posted - 2009-06-24 : 10:48:14
Just another note -
We use IE 7 as there was a noticable performance and stability improvement with what we were doing.
So if you can test IE 7 as a client, I would.


Greg E
Go to Top of Page
   

- Advertisement -