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.
jaxrpcAsked:
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.
0
 
Sreedhar VengalaSr. Consultant - Business IntelligenceCommented:
Do you need SQL part to get the result set based on your condition
Sum(GroupBy(name),absentperiod);
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].[Quantity])) AS [TotalUnitsInStock], [t0].[OrderID] AS [Category]
FROM [Order Details] AS [t0]
GROUP BY [t0].[OrderID]

using OrderDetails table from Northwind

0
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.