Saturday, January 23, 2021

SSRS Expressions

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


Fill / BackgroundColor for row in tablix:

=IIF(ROWNUMBER(Nothing) MOD 2, "#ADD8E6", "#FFFFFF")



Expression for File Name:


@[User::ExportPath] + "FILENAMEPREFIX_" + (DT_STR,4,1252)DATEPART("yyyy",GETDATE()) + RIGHT("00" + (DT_STR,2,1252)DATEPART("M", GETDATE()), 2) + RIGHT("00" + (DT_STR,2,1252)DATEPART("dd",GETDATE()), 2) + ".csv"




No comments:

Post a Comment