Last post Mar 23, 2012 07:21 AM by raivns1
Mar 21, 2012 04:50 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 !!!
Mar 21, 2012 10:59 AM|Ashutosh Pathak|LINK
write it like in your count text column value expression:
Mar 22, 2012 11:22 AM|raivns1|LINK
It is showing like that..............
Mar 23, 2012 12:01 AM|Ashutosh Pathak|LINK
right click on your column matrix that contain the date, add group total >> then pass this expression
Mar 23, 2012 05:02 AM|raivns1|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 05:56 AM|Ashutosh Pathak|LINK
did you use the expression in the count field.
Mar 23, 2012 06:17 AM|raivns1|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 06:20 AM|Ashutosh Pathak|LINK
right click on the data, and then add total
Mar 23, 2012 06:27 AM|raivns1|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 06:32 AM|Ashutosh Pathak|LINK
correct in the column's row field post your expression.
Mar 23, 2012 06:39 AM|raivns1|LINK
Noe it showing this
Mar 23, 2012 06:43 AM|raivns1|LINK
Mar 23, 2012 06:47 AM|Ashutosh Pathak|LINK
Did you write expression SUM(iif(Fields!AttendanceStatus.Value="A",1,0)) here???????????
Mar 23, 2012 06:49 AM|raivns1|LINK
Yes i have written on that place.
Mar 23, 2012 06:57 AM|raivns1|LINK
It is exactly like that.....................
Mar 23, 2012 07:11 AM|Ashutosh Pathak|LINK
give me the time till evening, i dont have access to sql and ssrs right now, once i'll reach home will try to find out the solution for u. please manage in between,.
Mar 23, 2012 07:21 AM|raivns1|LINK
Ok Boss !!!
i m using Sql Data Set and Asp.Net Report Viewer 3.5 not SSRS.
Thankx & Most Welcome !!!!