How do I Group some values and find their sum and display in agraph in asp .net

Question

0.00/5 (No votes)

See more:

Hi Dear All

Could anyone please tell me how to implement a chart in my asp .net web site application..

In my project there is a report. The report contains some columns like:

Person Name - These fields will be
Company Name - used only for grouping

Total Amount
Paid Amount
Balance Amount

The report has two grouping criteria. based on Person /based on Company.
If we choose Person then the sum of total amount,paid amount and balance amount will be calculated and displayed in the report.
eg:

before grouping
Name Totalamt Paid Balance
Alex 10000 3000 7000
Rojer 900 200 700
Rojer 3000 1300 1700
Alex 10000 5000 5000
Rojer 1100 500 600

after grouping.
Grouping: Person Name

Name Totalamt Paid Balance
Alex 20000 8000 12000
Rojer 5000 2000 3000

Please tell me how to display the report after grouping in a chart control(for eg: stacked chart) of my asp .net web site application.

Thak you

Posted 27-May-14 3:28am

SubhashRokzzz

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

**Nirav Prabtani** · Answer 1 · 2014-05-27T03:59:00

you can use this query. :)

SQL

select sum(ammount)as totalAmount,sum(paid) as paid ,sum(balance) as bamance,name from demo group by name

for chart control.. :)

ASP.NET 4.0 Chart Control[^]

ASP.NET Charting Controls[^]

Create ASP.Net Chart Control from Database using C# and VB.Net Example[^]

Bind ASP.NET chart control from database using C#
[^]

ZurdoDev · Answer 2 · 2014-05-27T03:50:00

Solution 1

There are many articles on this site that walk you through how to use the ASP.Net chart control.

For example:

ASP.NET 4.0 Chart Control[^]

and

ASP.NET Charting Controls[^]

Posted 27-May-14 3:50am

ZurdoDev