Posts

Showing posts from May, 2023

Add and Verify a Data Connection (Report Builder and SSRS)

https://learn.microsoft.com/en-us/sql/reporting-services/report-data/add-and-verify-a-data-connection-report-builder-and-ssrs  

Create, Modify, and Delete Shared Data Sources (SSRS)

https://learn.microsoft.com/en-us/sql/reporting-services/report-data/create-modify-and-delete-shared-data-sources-ssrs  

Role definitions - predefined roles

https://learn.microsoft.com/en-us/sql/reporting-services/security/role-definitions-predefined-roles  

E-Mail Delivery in Reporting Services

https://learn.microsoft.com/en-us/sql/reporting-services/subscriptions/e-mail-delivery-in-reporting-services  

Implement a Data Driven Subscription in SQL Server Standard Edition

https://www.sqlservercentral.com/articles/execute-a-data-driven-ssrs-subscription-from-ssis-to-archive-a-report   @EventData is the id of the subscription EXEC ReportServer . ado . AddEvent @ EventType = 'TimedSubscription' ,@ EventData = '31784d36-c544-4224-894c-a0de1d61a000'

Data Driven Subscription Workaround (Standard Edition)

https://www.sqlservercentral.com/articles/data-driven-subscription-workaround