Solved

Microsoft RDLC report

Posted on 2009-04-15
2
913 Views
Last Modified: 2012-05-06
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.
0
Comment
Question by:jaxrpc
2 Comments
 
LVL 9

Expert Comment

by:Sreedhar Vengala
ID: 24145819
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
 

Accepted Solution

by:
jaxrpc earned 0 total points
ID: 24146270
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

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction Although it is an old technology, serial ports are still being used by many hardware manufacturers. If you develop applications in C#, Microsoft .NET framework has SerialPort class to communicate with the serial ports.  I needed to…
The article shows the basic steps of integrating an HTML theme template into an ASP.NET MVC project
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question