{"id":81,"date":"2011-10-05T01:58:18","date_gmt":"2011-10-04T19:58:18","guid":{"rendered":"http:\/\/markwheeler.com\/wordpress\/?p=81"},"modified":"2011-10-05T01:58:18","modified_gmt":"2011-10-04T19:58:18","slug":"ssrs-sharepoint-integrated-mode-missing-subscribe-button","status":"publish","type":"post","link":"https:\/\/www.markwheeler.com\/?p=81","title":{"rendered":"SSRS Sharepoint Integrated Mode Missing Subscribe Button"},"content":{"rendered":"<p><a href=\"http:\/\/markwheeler.com\/wordpress\/wp-content\/uploads\/2011\/10\/Subscribe.png\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/markwheeler.com\/wordpress\/wp-content\/uploads\/2011\/10\/Subscribe.png\" alt=\"\" title=\"Subscribe\" width=\"148\" height=\"183\" class=\"alignleft size-full wp-image-82\" \/><\/a> Ran into an issue when running SQL 2008 R2 Reporting Services in Sharepoint 2010 Integrated Mode. Only those with Full Control permissions could see the Subscribe option in the Actions Menu. However, users could Manage Subscriptions from the Item drop-down menu in the Report library.<br clear=\"all\" \/><\/p>\n<p>By default, the OOB Permissions Levels do not have the Create Alerts option set. Here&#8217;s a way to create a Permission Level that will allow you to do that.<\/p>\n<p>Go to Site Actions > Site Settings > Site Permissions > Permissions Levels > Add a Permission Level<\/p>\n<p>In this case; I named it Report Permissions with the description of Create Alerts, Subscribe for Reporting Services.<br \/>\nUnder List Permissions; Click these Options:<br \/>\nEdit Items<br \/>\nView Items<br \/>\nOpen Items<br \/>\nView Versions<br \/>\nCreate Alerts<br \/>\nView Application Pages<\/p>\n<p>Under Site Permissions; Click these Options:<br \/>\nView Pages<br \/>\nBrowser User Information<br \/>\nUse Remote Interfaces<br \/>\nOpen<br \/>\nEdit Personal User Information<\/p>\n<p>Click Submit.<\/p>\n<p>Assign this Permission Level to your Viewers Group(s).<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ran into an issue when running SQL 2008 R2 Reporting Services in Sharepoint 2010 Integrated Mode. Only those with Full Control permissions could see the Subscribe option in the Actions Menu. However, users could Manage Subscriptions from the Item drop-down menu in the Report library. By default, the OOB Permissions [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"footnotes":""},"categories":[2,10,11],"tags":[91,102,106],"class_list":["post-81","post","type-post","status-publish","format-standard","hentry","category-computer","category-sharepoint","category-software","tag-report-viewer-action-menu","tag-sharepoint-integrated-mode","tag-sql-reporting-services"],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/www.markwheeler.com\/index.php?rest_route=\/wp\/v2\/posts\/81","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.markwheeler.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.markwheeler.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.markwheeler.com\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.markwheeler.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=81"}],"version-history":[{"count":0,"href":"https:\/\/www.markwheeler.com\/index.php?rest_route=\/wp\/v2\/posts\/81\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.markwheeler.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=81"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.markwheeler.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=81"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.markwheeler.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=81"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}