Data Driven Subscription Workaround

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

Data-Driven Subscriptions

 https://learn.microsoft.com/en-us/sql/reporting-services/subscriptions/data-driven-subscriptions?view=sql-server-ver16

Reporting Services Subscriptions in SQL Server 2019

https://www.mssqltips.com/sqlservertip/6616/ssrs-data-driven-subscription/

 

Footer

="Report Executed At: " & Globals!ExecutionTime

="Run By: " & User!UserID

="Data Last Refreshed: " & First(Fields!LAST_REFRESH_DATE.Value, "LastRefreshDateTime")

Decision Functions

https://www.sqlchick.com/entries/2010/9/6/decision-functions-in-ssrs.html 

Code to Get Current User

 Add a hidden parameter Report_User

Add custom code:

Public Function GetUser() as String

Try

return Report.User!UserID.ToLower()

Catch

Return "sqllogin"

End Try

End Function

Show Heading on Every Page

Click the glyph on Column Groups and select Advanced

Click the first (Static) row under Row Groups

Set Other Properties:

DataElementOutput: Auto

FixedData: True

hideIfNoRows: False

KeepTogether: False

KeepWithGroup: After

RepeatOnNewPage: True