Programmabilities Blog

• 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")

• *http://www.ssw.com.au/Ssw/Standards/Rules/RulesToBetterSQLReportingServices.aspx
• http://download.microsoft.com/download/1/3/4/134644fd-05ad-4ee8-8b5a-0aed1c18a31e/reporting_services_design.doc
• http://notethat.blogspot.com/2007/10/reporting-services-tips-tricks-and.html

Labels: sql

- posted by programmabilities @ 12:51