Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Mar 23, 2012 11:21 AM by raivns1
Mar 21, 2012 08:50 AM|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 !!!
Mar 21, 2012 02:59 PM|LINK
write it like in your count text column value expression:
Mar 22, 2012 03:22 PM|LINK
It is showing like that..............
Mar 23, 2012 04:01 AM|LINK
right click on your column matrix that contain the date, add group total >> then pass this expression
Mar 23, 2012 09:02 AM|LINK
Noe it is counting entire records at a time like showing below.
I want to count employee wise absent and present
Mar 23, 2012 09:56 AM|LINK
did you use the expression in the count field.
Mar 23, 2012 10:17 AM|LINK
I am using Asp.net Report Viewer and i have done all the things u told.
where i should add count either in row group or in column group.
there r only one option showing which is subtotal not like group total.
Can you tell me exat steps to do that.
Mar 23, 2012 10:20 AM|LINK
right click on the data, and then add total
Mar 23, 2012 10:27 AM|LINK
After that it showing a column right side date column with named total.
I have done already it is showing same that i posted earlier.
where i should add exprssion,on place of title or below that.
Mar 23, 2012 10:32 AM|LINK
correct in the column's row field post your expression.