jaxrpc
asked on
Microsoft RDLC report
Hi,
How do i make a sub total of a field for every group in table? example for data grouped by name, for every name i want to get the total number of days he is absent.
thanks.
How do i make a sub total of a field for every group in table? example for data grouped by name, for every name i want to get the total number of days he is absent.
thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Sum(GroupBy(name),absentpe
do able with linq:
var orders =
from o in OrderDetails
group o by o.OrderID into oID
select new {Category = oID.Key, TotalUnitsInStock = oID.Sum(o=>o.Quantity)};
orders.Dump();
SQL:
SELECT SUM(CONVERT(Int,[t0].[Quan
FROM [Order Details] AS [t0]
GROUP BY [t0].[OrderID]
using OrderDetails table from Northwind