Tuesday, November 11, 2014

Unable to see download icon for SSRS Report in Report Manager

Recently I was working on SSRS 2008 R2 version and I had to analyse one SSRS report which was already published in Report Manager.

Normally in SSRS 2005, we get an "Edit" option from which we can download.

I knew this option to download RDL file was improved in SSRS 2008 R2. If we just hover over the SSRS report and click the icon we get many options such as download/subscription and many more.

But this time I was not able to find a single option.

It was looking some thing as below


Solution:
From one of the forum , I got to know that report link needs to be added to the "Compatibility View Setting" of the browser.

To do this, in IE, click the setting button and select "Compatibility View Settings" as shown below:

Now, add the link in the box and click Add as shown below and then close the window
Now, when I went back to report manager and refreshed it, I was able to see all the options and I could download the RDL file
Reference :
http://stackoverflow.com/questions/15144158/can-not-open-the-drop-down-arrow-besides-the-report-in-ssrs-report-manager-to-ad