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