My SSRS Nuggets

https://www.brentozar.com/archive/2025/06/sql-server-reporting-services-is-dead-is-ssis-next/  

https://stackoverflow.com/questions/25943877/is-there-a-way-to-query-future-ssrs-subscription-schedules   has several T-SQL examples

https://www.sqlservercentral.com/forums/topic/how-to-get-a-list-of-ssrs-schedules-for-subscriptions   SELECT S . ScheduleID , C .[ Path ] ObjectPath , U . UserName , SB .[ Description ], S . StartDate , S . LastRunTime FROM ReportServer . dbo . ReportSchedule RS INNER JOIN ReportServer . dbo . Schedule S ON S . ScheduleID = RS . ScheduleID INNER JOIN ReportServer . dbo .[ Catalog ] C ON C . ItemID = RS . ReportID INNER JOIN ReportServer . dbo . Subscriptions SB ON SB . SubscriptionID = RS . SubscriptionID INNER JOIN ReportServer . dbo . Users U ON U . UserID = SB . OwnerID

https://www.mssqltips.com/sqlservertip/3078/report-launcher-to-run-ssrs-report-subscriptions-on-demand/  

https://www.mssqltips.com/sqlservertip/1846/how-to-easily-identify-a-scheduled-sql-server-reporting-services-report/  

https://techcommunity.microsoft.com/blog/coreinfrastructureandsecurityblog/ssrs-subscriptions-what-goes-on-under-the-hood/370746   SELECT n.SubscriptionID ,c.Name AS ReportName ,c.Path AS ReportPath ,u.UserName AS SubscriptionOwner ,n.ExtensionSettings ,n.NotificationEntered AS QueuedSinceTime ,n.ProcessAfter ,n.SubscriptionLastRunTime ,n.DeliveryExtension FROM dbo.Notifications n WITH (NOLOCK) INNER JOIN dbo.CATALOG c WITH (NOLOCK) ON n.ReportID = c.ItemID INNER JOIN dbo.Users u WITH (NOLOCK) ON n.SubscriptionOwnerID = u.UserID WHERE n.ProcessStart IS NULL AND ( n.ProcessAfter IS NULL OR n.ProcessAfter < GETUTCDATE() ) ORDER BY n.NotificationEntered

https://learn.microsoft.com/en-us/sql/reporting-services/install-windows/subscription-settings-and-a-file-share-account-configuration-manager?view=sql-server-ver17  

https://www.sqlshack.com/enhancing-customer-experiences-with-subscriptions-in-ssrs/  

https://learn.microsoft.com/en-us/sql/reporting-services/report-server-web-service/net-framework/reporting-services-delivery-extension-settings?view=sql-server-ver16  

  https://www.sqlshack.com/ssrs-failed-subscription-alerting/

https://learn.microsoft.com/en-us/answers/questions/1162118/ssrs-processing-0-processed-of-251-total-0-errors  

Google search:   https://www.google.com/search?q=create+data+driven+subscription+schema+error

https://sqlserverbi.blog/05-parse-multi-value-parameters-with-openjson/  

https://learn.microsoft.com/en-us/archive/blogs/deanka/monitoring-and-troubleshooting-subscriptions  

https://garrybargsley.com/2021/11/16/decoding-ssrs-subscription-agent-jobs/   Get the SQL Agent Job Name from this query. Filter on c.Path to locate the report you're looking for. SELECT sj.name AS [SQL Job Name],        c.Path,        c.name,        s.LastRunTime,        s.description,        s.LastStatus,        u.UserName,        s.SubscriptionID FROM ReportServer..Subscriptions s     INNER JOIN ReportServer..Users u         ON s.OwnerID = u.UserID     INNER JOIN ReportServer..Catalog c         ON s.Report_OID = c.ItemID     INNER JOIN msdb..sysjobsteps sjs         ON sjs.command LIKE '%' + CAST(s.SubscriptionID AS VARCHAR(4000)) + '%'     INNER JOIN msdb..sysjobs sj         ON sj.job_id = sjs.job_id WHERE c.Path like '%Thi...

https://learn.microsoft.com/en-us/sql/reporting-services/subscriptions/file-share-delivery-in-reporting-services   To include a timestamp in the file name, add the  @timestamp  variable to the file name (for example,  CompanySales@timestamp ). 

https://www.sqlservercentral.com/articles/dynamically-name-reportfile-export-in-ssrs  

Click on the Group in Row Groups, expand the Group in the Properties window, set the PageName property which becomes the Sheet Name.

https://learn.microsoft.com/en-us/sql/reporting-services/report-builder/exporting-to-microsoft-excel-report-builder-and-ssrs?view=sql-server-ver16  

https://learn.microsoft.com/en-us/sql/reporting-services/report-design/nested-data-regions-report-builder-and-ssrs