SSRS :
Page Header:
TextBox via Expression...: =Globals.ReportFolder & Globals.ReportName
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)", ""))
)
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")
No comments:
Post a Comment