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
Present.
write it like in your count text column value expression:
=SUM(iif(Fields!AttendanceStatus.Value="A",1,0))
Ashutosh Pathak
Blog: http://catchcode.blogspot.com Please mark it as answer if it helps, as clicking on the button can save time of others :)
MCP,MCAD,MCSD,MCTS
right click on your column matrix that contain the date, add group total >> then pass this expression
Ashutosh Pathak
Blog: http://catchcode.blogspot.com Please mark it as answer if it helps, as clicking on the button can save time of others :)
MCP,MCAD,MCSD,MCTS
Ashutosh Pathak
Blog: http://catchcode.blogspot.com Please mark it as answer if it helps, as clicking on the button can save time of others :)
MCP,MCAD,MCSD,MCTS
Ashutosh Pathak
Blog: http://catchcode.blogspot.com Please mark it as answer if it helps, as clicking on the button can save time of others :)
MCP,MCAD,MCSD,MCTS
correct in the column's row field post your expression.
Ashutosh Pathak
Blog: http://catchcode.blogspot.com Please mark it as answer if it helps, as clicking on the button can save time of others :)
MCP,MCAD,MCSD,MCTS
raivns1
Member
28 Points
23 Posts
Problem in Report Viewer .................
Mar 21, 2012 08:50 AM|LINK
Hi Team,
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 Present.
format is give below.............
Only count Absent and Present don't count SA.
Please help me asap.
Thank You !!!
Regards,
Deepak Rai
Noida
Ashutosh Pat...
Contributor
5737 Points
1105 Posts
Re: Problem in Report Viewer .................
Mar 21, 2012 02:59 PM|LINK
write it like in your count text column value expression:
=SUM(iif(Fields!AttendanceStatus.Value="A",1,0))
Blog: http://catchcode.blogspot.com
Please mark it as answer if it helps, as clicking on the button can save time of others :)
MCP,MCAD,MCSD,MCTS
raivns1
Member
28 Points
23 Posts
Re: Problem in Report Viewer .................
Mar 22, 2012 03:22 PM|LINK
It is showing like that..............
Ashutosh Pat...
Contributor
5737 Points
1105 Posts
Re: Problem in Report Viewer .................
Mar 23, 2012 04:01 AM|LINK
right click on your column matrix that contain the date, add group total >> then pass this expression
Blog: http://catchcode.blogspot.com
Please mark it as answer if it helps, as clicking on the button can save time of others :)
MCP,MCAD,MCSD,MCTS
raivns1
Member
28 Points
23 Posts
Re: Problem in Report Viewer .................
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
Ashutosh Pat...
Contributor
5737 Points
1105 Posts
Re: Problem in Report Viewer .................
Mar 23, 2012 09:56 AM|LINK
did you use the expression in the count field.
SUM(iif(Fields!AttendanceStatus.Value="A",1,0))
Blog: http://catchcode.blogspot.com
Please mark it as answer if it helps, as clicking on the button can save time of others :)
MCP,MCAD,MCSD,MCTS
raivns1
Member
28 Points
23 Posts
Re: Problem in Report Viewer .................
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.
Thank You !!!
Ashutosh Pat...
Contributor
5737 Points
1105 Posts
Re: Problem in Report Viewer .................
Mar 23, 2012 10:20 AM|LINK
right click on the data, and then add total
Blog: http://catchcode.blogspot.com
Please mark it as answer if it helps, as clicking on the button can save time of others :)
MCP,MCAD,MCSD,MCTS
raivns1
Member
28 Points
23 Posts
Re: Problem in Report Viewer .................
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.
Thank You !!!
Ashutosh Pat...
Contributor
5737 Points
1105 Posts
Re: Problem in Report Viewer .................
Mar 23, 2012 10:32 AM|LINK
correct in the column's row field post your expression.
Blog: http://catchcode.blogspot.com
Please mark it as answer if it helps, as clicking on the button can save time of others :)
MCP,MCAD,MCSD,MCTS