Data Driven Subscription Miscellaneous Notes

Specify delivery extension settings for Report Server FileShare: 
File Extension may need to be static value of true or false.  I selected Get the value from the database and an error was raised when running the subscription.

Export SQL Server Reporting Services Report Data into Multiple Excel Worksheets

https://www.mssqltips.com/sqlservertip/3527/export-sql-server-reporting-services-report-data-into-multiple-excel-worksheets/

Monitoring and Troubleshooting Subscriptions

https://blogs.msdn.microsoft.com/deanka/2009/01/13/monitoring-and-troubleshooting-subscriptions/

Troubleshooting Subscriptions: Part II, Using the Reporting Services Trace Log File

https://blogs.msdn.microsoft.com/deanka/2010/02/15/troubleshooting-subscriptions-part-ii-using-the-reporting-services-trace-log-file/

SSRS Subscription: How to Dynamically Generate Exported Filenames

http://blog.aajtech.com/blog/ssrs-subscription-how-to-dynamically-generate-exported-filenames/

Extracting SSRS Report RDL (XML) from the ReportServer database

http://bretstateham.com/extracting-ssrs-report-rdl-xml-from-the-reportserver-database/

Make Reports Not Used Obsolete

http://www.sqlservercentral.com/articles/Reporting+Services+(SSRS)/155104/

SQL Server Reporting Services (SSRS) Log Files for Troubleshooting

https://www.mssqltips.com/sqlservertip/3348/sql-server-reporting-services-ssrs-log-files-for-troubleshooting/

A Single-Parameter Date Range in SQL Server Reporting Services

http://www.sqlservercentral.com/articles/Reporting+Services+(SSRS)/133147/

PowerShell Commands for SSRS

https://www.mssqltips.com/sqlservertip/4738/powershell-commands-for-sql-server-reporting-services/

Dynamic SSRS report documentation via a ReportServer.dbo.Catalog query

http://www.sqlservercentral.com/articles/Reporting+Services+(SSRS)/152814/

My Favorite SSRS Interview Questions

Report Subscriptions

Data-Driven Subscriptions

Linked Report

Report Parameters / Cascading parameters

Processing options: most recent data, cache, or snapshot

Cache refresh options

Report history

Snapshot options

What built-in logging does SSRS provide?

How can you run a subscription on demand? use ReportServer.dbo.AddEvent stored proc

Get the last execution run time of every report

/*

SCRIPT: GET_LAST_REPORT_EXECUTION_TIME

get the last execution run time of every report

*/

SELECT
  ItemPath
, MAX(TimeStart) RunTime
FROM [dbo].[ExecutionLog3]
GROUP BY ItemPath, TimeStart
ORDER BY 2 DESC

Execute a data-driven SSRS subscription from SSIS to archive a report

http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/141407/

Trigger an Email of an SSRS Report from an SSIS Package

http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/96275/

SSRS Web Service

http://<Server Name>/ReportServer/ReportService2010.asmx?wsdl

Data Driven Subscriptions

https://msdn.microsoft.com/en-us/library/ms159150(v=sql.120).aspx

Branding the web portal

https://msdn.microsoft.com/en-us/library/mt710551.aspx

What's New in SSRS 2016 and later?

https://msdn.microsoft.com/en-us/library/ms170438(v=sql.130).aspx

TIPS AND TRICKS FOR ENSURING CONSISTENCY IN SQL SERVER REPORTING SERVICES REPORTS

https://www.3pillarglobal.com/insights/tips-tricks-ensure-consistency-sql-server-reporting-services-reports

Subscriptions and Delivery

https://msdn.microsoft.com/en-us/library/ms159762(v=sql.120).aspx

Bulk Report Generation using SSIS and SSRS 2008 R2

https://technet.microsoft.com/en-us/library/ff793463(v=sql.105).aspx

Execute SSRS Report from SSIS

https://www.mssqltips.com/sqlservertip/3475/execute-a-sql-server-reporting-services-report-from-integration-services-package/

Create a Data-Driven Subscription

https://msdn.microsoft.com/en-us/library/ms169673(v=sql.120).aspx

Report launcher to run SSRS report subscriptions on demand

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

Analyze Report Execution and Usage Statistics in SQL Server Reporting Services

https://www.mssqltips.com/sqlservertip/1908/analyze-report-execution-and-usage-statistics-in-sql-server-reporting-services/

ExecutionLog2 View – Analyzing and Optimizing Reports

https://blogs.msdn.microsoft.com/robertbruckner/2009/01/06/executionlog2-view-analyzing-and-optimizing-reports/

Querying the Report Server Execution Log

http://www.sqlchick.com/entries/2011/2/6/querying-the-report-server-execution-log.html