Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Microsoft RDLC report

Posted on 2009-04-15
2
Medium Priority
?
921 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

This article describes a simple method to resize a control at runtime.  It includes ready-to-use source code and a complete sample demonstration application.  We'll also talk about C# Extension Methods. Introduction In one of my applications…
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

618 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