Bookmark and Share Subscribe Bookmark and Share

Categories

Advertisement



Reporting Services – Missing “Export” to function

Feb
17

 « »    
Below is a question I answered on the MSDN/Technet forum. This question was marked as a correct answer by forum administrators or by the user that asked the question.

The original link to this question is (a new window will open):
[custom_field field="MSDNLink" this_post="1" limit="1" between=", ""] .

This question was originally answered on [custom_field field="MSDNDate" this_post="1" limit="1" between=", ""].

Please scroll down to read all of the forum entries.

We have a SQL Server 2008 R2 Reporting Service running in Sharepoint integrated mode. Everything is working fine, we have already set up a Sharepoint library for storing reports. When I log in with a Farm administrator account (or with an account that has Full permission on the site), I can make subscriptions in reports and even export them to Excel, etc. But when I log in with a different account that has only Read permission, I cannot set up subscriptions and the Export to menu is empty. How can I grant this missing functions to users?

AnswerReporting service – missing “Export” to function

  • Monday, December 13, 2010 2:43 PMmrgabriel Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals

     

    Hello,

     

    We have a SQL Server 2008 R2 Reporting Service running in Sharepoint integrated mode.

    Everything is working fine, we have already set up a Sharepoint library for storing reports.

     

    When I log in with a Farm administrator account (or with an account that has Full permission on the site), I can make subscriptions in reports and even export them to Excel, etc.

     

    But when I log in with a different account that has only Read permission, I cannot set up subscriptions and the Export to menu is empty.

     

    How can I grant this missing functions to users?

     

    Thanks.

Answers

  • Monday, December 13, 2010 4:27 PMJPPinto.com Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals

     Answer
    Try a different level of built in permissioning, maybe contribute. If you do not want them to have that level of access then you may need to create a custom level of security so at minimum they can export and subscribe.
    • Marked As Answer bymrgabriel Tuesday, December 14, 2010 8:14 AM
    •  

All Replies

  • Monday, December 13, 2010 4:27 PMJPPinto.com Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals

     Answer
    Try a different level of built in permissioning, maybe contribute. If you do not want them to have that level of access then you may need to create a custom level of security so at minimum they can export and subscribe.
    • Marked As Answer bymrgabriel Tuesday, December 14, 2010 8:14 AM
    •  
  • Tuesday, December 14, 2010 8:19 AMmrgabriel Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals

     

    Thank you, changing the permission to Contribute solved the missing export function.

     

    If anyone facing similar problem, check the following article:

    http://msdn.microsoft.com/en-us/library/bb326286.aspx

     

    I’m wondering, why there isn’t built-in permission levels in Sharepoint for reporting service…



Leave a comment

Trackbacks on this post