Monday, 12 April 2010

SSRS Time And Total

To display date and time

= FORMAT(Globals!ExecutionTime, "MM/dd/yyyy hh:mm tt")

Only Time

= FORMAT(Globals!ExecutionTime, "hh:mm tt")


And To get

Total No Of Lines e.g. =Count(Fields!Account_ID.Value)

Sum Of Particular Field e.g. =sum(Fields!No_of_Times_Logged.Value)


To get Between WeekDays

="User Registered " & now().AddDays(-7).tostring("dd/MM/yyyy") & " - " & now().AddDays(-1).tostring("dd/MM/yyyy")

To get Between Months

="Oracle Core Idea Last Month Stats Rerport ( " & now().AddMonths(-1).Adddays(-(today.DAY-1)).tostring("dd/MM/yyyy") & " - " & today.Adddays(-(today.DAY-1)).tostring("dd/MM/yyyy") & " )"


No comments:

Post a Comment