-
Page Header:
-
TextBox via Expression...:
=Globals.ReportFolder & Globals.ReportName
-
TextBox via Expression...:
-
Page Footer:
-
Page Footer: TextBox via Expression...:
=Format(Globals!PageNumber) & " of " & Format(Globals!TotalPages) & " pages"
-
="Printed by " & User!UserID & " on " & DateTime.Now.ToString()
-
="Execution Time: " & IIF(System.DateTime.Now.Subtract(Globals!ExecutionTime).TotalSeconds < 1, "0 seconds", ( IIF(System.DateTime.Now.Subtract(Globals!ExecutionTime).Hours > 0, System.DateTime.Now.Subtract(Globals!ExecutionTime).Hours & " hour(s), ", "") & IIf(System.DateTime.Now.Subtract(Globals!ExecutionTime).Minutes > 0, System.DateTime.Now.Subtract(Globals!ExecutionTime).Minutes & " minute(s), ", "") & IIf(System.DateTime.Now.Subtract(Globals!ExecutionTime).Seconds > 0, System.DateTime.Now.Subtract(Globals!ExecutionTime).Seconds & " second(s)", "")) )
-
Page Footer: TextBox via Expression...:
-
Body:
-
TextBox via Expression...:
=Format(Sum(Fields!Account.Value), "C0")
(Works if column is numeric data type.) -
Alternate rows by adding the following to the row via Properties > BackgroundColor expression of your detail row:
=IIF(RowNumber(Nothing) Mod 2, "White", "Gainsboro")
-
TextBox via Expression...:
- msdn.microsoft.com/en-us/library/aa337293.aspx
- *en.csharp-online.net/Building_Reports_in_SQL_Server_2005
- *ssw.com.au/Ssw/Standards/Rules/RulesToBetterSQLReportingServices.aspx
- download.microsoft.com/download/1/3/4/134644fd-05ad-4ee8-8b5a-0aed1c18a31e/reporting_services_design.doc
- notethat.blogspot.com/2007/10/reporting-services-tips-tricks-and.html