Last post Mar 20, 2012 08:25 AM by raivns1
Mar 20, 2012 08:25 AM|raivns1|LINK
i have created a Report using Matrix Report Viewer.Sql Table has three columns EmployeeId,Date and AttendanceStatus.
in Matrix report viewer EmployeeId is Row,Date is Column and AttendanceStatus is Deatils.i want to add to extra virtual columns here which will display total absent and total present based on values in AttendanceStatus columnslike A for Absent and P for
format is give below.............
Only count Absent and Present don't count SA.
Please help me asap.
Thank You !!!