Saturday, February 02, 2013 7:35 PM
Hi i am facing a problem in my SSRS Report where there are two column groupings on the report. Ex: parent group is Location_Head, chiled group is Location. i need to find out the Count of Employees attendence where it was marked as "WO" (Week off).
Columns in my report are like following
Location Head, Location, Attendace, Week Off (here i need to find out the count of employees where there attendece was marked as WO)
Please provied me a expression to find out the count off employees who's attendence been marked as WO.
Location Head(Group) Location(Group) Total Attendance(total num of empls working in the location under the Loc_Head) WeekOff
Jack USA 9 9 (0n_sundays)
Jim UK 10 10 "
i have a data parameeters too on this report...
so on week days week offs will disply 0 and on week ends is displays total attendance
Thanks & Regards $@m
Sunday, February 03, 2013 9:03 AM
ok basically you want the total number of employees to show different values based on what day the report is ran, that if i understood you correctly.
so an expression sample would be :
=IIF(Weekdayname(Globals!ExecutionTime) = "Saturday", <<value for weekend>>, IIF( Weekdayname(Globals!ExecutionTime) = "Sunday", <<value for weekend>> , <<value for weekdays>>))
hope this helps
Teddy Bejjani - BI Specialist @ Netways
Sunday, February 03, 2013 11:03 AM
Hi teddy.. thanks for your reply... in my case we don't need to bother about day.. i mentioned days(sunday) just for understanding... i wanted to calculate count of people who's attendance has been marked as WO (week off ) in Attendance column and display in Week Off Column... if the day is week end, i should get total number of employees. since every one's status will be marked as WO in Attendance column. if the day is working day i need to get count of employees who's attendance marked as 'WO' in attendance. most of the time it will be 0. in some cases for few employees Week ends will be in working days. So, in both cases expression will be same.
in Attendance column i have status like WO(Week off), P(Present), OT(Over time).. etc.
Thanks & Regards $@m
Monday, February 04, 2013 6:21 AMModerator
If I understanding correctly, you want to correct the count of "Week off" employees based on the "Attendance" filed in the report.
Please refer to the following expression:
TechNet Community Support