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