Microsoft RDLC report


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.

Who is Participating?
jaxrpcConnect With a Mentor Author Commented:
Sorry. i think i did not explain clearly. I am talking about Table in the RDLC report not the database table.

Anyway for my problem, i have figured out the way to accomplish what i want. Just do a SUM(fields!yourField.Value) at the group footer of the RDLC report.
Sreedhar VengalaSr. Consultant - Business IntelligenceCommented:
Do you need SQL part to get the result set based on your condition
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)};


SELECT SUM(CONVERT(Int,[t0].[Quantity])) AS [TotalUnitsInStock], [t0].[OrderID] AS [Category]
FROM [Order Details] AS [t0]
GROUP BY [t0].[OrderID]

using OrderDetails table from Northwind

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.