Matt-Engel Blog

What to do when… SSRS Reports in SharePoint 2010 do not display the Export options

What to do when…  SSRS Reports in SharePoint 2010 do not display the Export options

It can be rather frustrating for an end user when they are unable to export their favorite reports to excel or another medium.  Here’s the solution to this problem.

Internet Explorer Settings

This issue comes from IE not recognizing the site as a trusted location.
In Internet Explorer, you need to go into: Tools > Internet Options

  1. Hit the Security Tab
  2. Choose Local Intranet
  3. Hit the Sites Button
  4. Hit the Advanced Button

You can add multiple items here, or if there are several sites in the same domain you can use a wild card. (ie. http://*.MyDomain.com)Hit the Security Tab

Close out of all the screens and close out IE.  Restart IE and you should be able to export the reports…

Local Intranet SettingsI have witnessed this issue numerous times and it appears to happen on a machine that has already had these settings adjusted after Internet Explorer gets automatic updates pushed out to them.

Please let me know if you have any problems with this solution, or if you have found other causes for this information to get wiped out.

Cheers!

0


About the Author:

I have been in Information Technology Professional for 15 years and have settled into the realm of Microsoft SharePoint. I have been a SharePoint Administrator for an International Corporation based out of Michigan since 2011. My reasons for starting this site, much like anyone else who focuses on SharePoint, is to share what I have learned along my career path as an Administrator for a medium sized company. Most of what I have been jotting down for the past year are issues that I had come across while working with an inherited SharePoint 2010 environment. There are pitfalls that I will discuss along with some of the things that we had to develop on our own that SharePoint didn't quite do on its own. I hope you will find the content both helpful and entertaining. Cheers!

Add a Comment

CommentLuv badge