Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Reporting services export to Excel Expand / Collapse
Author
Message
Posted Tuesday, November 01, 2011 6:25 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, April 26, 2012 9:13 AM
Points: 14, Visits: 70
Hi all

When an user export a report to excel or to any applicaiton after running a SSRS report from internet explorer , it wont export and just creats an empty tab on internet explorer.

But for other users it works fine. The above user has got new computer and before she could export it on older computer. Is there any setting I need to do on Internet explorer or anything? Right now it just creates blank tab after clicking export button.

Please help

Thanks
Post #1198609
Posted Tuesday, November 01, 2011 6:30 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Thursday, January 16, 2014 12:03 PM
Points: 21,376, Visits: 9,594
Have you checked what's happening server side?


Query stuck?
Rendering stuck?

Anything in any of the logs?

Exec log, windows & sql logs?


Can you export the same report with the same parameters on another machine?



Anything else points to clone the old machine and rebuild the new one from that, which I'm sure you want to avoid!
Post #1198612
Posted Tuesday, November 01, 2011 6:37 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, April 26, 2012 9:13 AM
Points: 14, Visits: 70
Thanks for reply

All other users can export the report easily. This user has only problem. I am how and which logs I need to look at. The report running fine and users been using from long time , its just export to excel.

This user's PC was upgraded from XP to Windows 7. Its same PC but formatted and upgraded by IT department. PC works fine and so does the internet explorer. I am thinking is there any setting need to be done? I can't go back to IT dept and tell them to check as they dont have a clue what SSRS is so they will not look into this problem.

Its something I need to do myself.

Thanks.
Post #1198618
Posted Tuesday, November 01, 2011 6:40 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Thursday, January 16, 2014 12:03 PM
Points: 21,376, Visits: 9,594
Did he upgrade from excel 2k3 to 2k7 or 10?


I can't think of nothing else!
Post #1198621
Posted Tuesday, November 01, 2011 6:48 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, April 26, 2012 9:13 AM
Points: 14, Visits: 70
Possibly. But it wont export to any format. Not to PDF even or anything else. So I am assuming its problem in internet explorer. Why it opens a blank tab when export button is being clicked?
Is there any case this user might not have permissions to download or something? But same time I believe she can download other stuff.

Strange I know but please if you can help me will be much appreciated.

Post #1198628
Posted Tuesday, November 01, 2011 8:16 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Thursday, January 16, 2014 12:03 PM
Points: 21,376, Visits: 9,594
Try adding the site to safe zone and then putting the security to the lowest level.

That's the only thing that could block this in IE that I know of.
Post #1198694
Posted Wednesday, November 02, 2011 5:33 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, April 26, 2012 9:13 AM
Points: 14, Visits: 70
Hi

The problem was in IE it self, New tab wasn't working. I fixed it by running a fix for it. I guess its bug from Microsoft.


Thanks.
Post #1199206
Posted Wednesday, November 02, 2011 5:34 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Thursday, January 16, 2014 12:03 PM
Points: 21,376, Visits: 9,594
Do you have a link that details that info? I'm sure a lot of people might need that info in the near future.
Post #1199209
Posted Wednesday, November 02, 2011 5:40 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, April 26, 2012 9:13 AM
Points: 14, Visits: 70
http://social.technet.microsoft.com/Forums/en/ieitprocurrentver/thread/cf38b0ae-34f6-4f0b-9b45-7a6e41ef014a

Above is the link. When I was clicking on export in SSRS report, it opens new tab and exports to excel or whatever. As new tab wasn't working it was just giving me blank tab.
Post #1199213
Posted Wednesday, November 02, 2011 5:46 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Thursday, January 16, 2014 12:03 PM
Points: 21,376, Visits: 9,594
TX
Post #1199217
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse