Applying Parameter Default Value Using Custom Code

http://www.statslice.com/ssrs-applying-parameter-default-value-using-custom-code

How To Create a Multi-option Parameter Report In SQL Server Reporting Services (SSRS)

https://dzone.com/articles/how-to-creat-multi-option-parameter-report-in-sql

Setting SQL Server Reporting Services Parameters Based On Other Parameters’ Values

https://36chambers.wordpress.com/2011/02/20/setting-sql-server-reporting-services-parameters-based-on-other-parameters-values/

Expression Examples

https://docs.microsoft.com/en-us/sql/reporting-services/report-design/expression-examples-report-builder-and-ssrs?view=sql-server-ver15

Passing multiple value parameters in data driven subscriptions

https://www.bigdatamark.com/ssrs-passing-multiple-value-parameters-in-data-driven-subscriptions/

Change PowerPoint Rendering Options

https://docs.microsoft.com/en-us/sql/reporting-services/pptx-device-information-settings?view=sql-server-ver15

https://docs.microsoft.com/en-us/sql/reporting-services/customize-rendering-extension-parameters-in-rsreportserver-config?view=sql-server-ver15

Data Driven Subscription Email Setup Notes

I wanted to deliver data-driven subscriptions via email. Here's how I used my Office 365 account for the smtp server:

Server Address: smtp.office365.com

Port Number: 587

The Report Server Configuration Manager's E-mail settings doesn't allow you to enter the STMP port number. I had to open up the rsreportserver.config file and enter it. I'm using SSRS 2019 and I found the rsreportserver.config file in the folder C:\Program Files\Microsoft SQL Server Reporting Services\SSRS\ReportServer.

Find the <Extension Name="Report Server Email" section and set <SMTPServerPort>587</SMTPServerPort>

Install SSRS 2019

Download SSRS 2019
https://www.microsoft.com/en-us/download/details.aspx?id=100122

https://docs.microsoft.com/en-us/sql/reporting-services/install-windows/install-reporting-services?view=sql-server-ver15

Generate T-SQL to Manually Execute Report Subscriptions

DECLARE @sql varchar(max);

set @sql = '';

select @sql = @sql + 'exec ReportServer.dbo.AddEvent @EventType=''TimedSubscription'', @EventData=''' 

 + cast(Subscriptions.SubscriptionID as varchar(500)) + ''';' + '--- '+ [catalog].name + CHAR(13) 

FROM ReportSchedule 

 INNER JOIN Schedule ON ReportSchedule.ScheduleID = Schedule.ScheduleID 

 INNER JOIN Subscriptions ON ReportSchedule.SubscriptionID = Subscriptions.SubscriptionID 

 INNER JOIN [Catalog] ON ReportSchedule.ReportID = [Catalog].ItemID 

 AND Subscriptions.Report_OID = [Catalog].ItemID

 WHERE Subscriptions.DeliveryExtension = 'Report Server Email'

 -- show only failed

 --and LEFT (subscriptions.LastStatus, 12) != 'Mail sent to'

 --and convert(varchar(20),Subscriptions.lastruntime, 101) = convert(varchar(20),getdate(), 101);

--EXEC(@sql);

print @sql​

Querying the Report Server Execution Log

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