Solved

sum up some tablefields and build chart

Posted on 2000-02-16
4
137 Views
Last Modified: 2010-04-04
hi, im a learner of delphi at the moment and wrote a small application. in this app. i have a table with numeric values. what im trying to do now is sum up a few of this values and automatically build a chart with these sums and then store the chart under a certain name. i tried several queries with sum but none worked. i hope u can help me find a solution, thx
0
Comment
Question by:ugross
  • 2
  • 2
4 Comments
 
LVL 12

Expert Comment

by:rwilson032697
ID: 2530100
You can sum a field in a table like this:

select sum(Afield) as FieldSum from ATable where ATable.AnotherField = 42

Cheers,

Raymond.
0
 

Author Comment

by:ugross
ID: 2530110
hi, sounds pretty simple and ok will try it, do u have any idea how to put these value straight into a chart. cheers

0
 
LVL 12

Accepted Solution

by:
rwilson032697 earned 100 total points
ID: 2530124
You can so this using a TChart (in the additional tab).

Add one of these to a form, create an appropriate series and use code somethting like this to fill it in:

(This is a snip from my Mortgage Planning app where it creates a chart of interest and principal payments over time)

  for I := 0 to CurrentScenario.Payments.Count - 1 do
    begin
      TotalScenarioInterest := TotalScenarioInterest + CurrentScenario.payments[i].InterestPortion;

      ScenarioPrincipalSeries.AddXY(CurrentScenario.Payments[i].PaymentDate,
                                    CurrentScenario.Payments[i].PrincipalRemaining, '', clTeeColor);
      ScenarioInterestSeries.AddXY(CurrentScenario.Payments[i].PaymentDate,
                                   TotalScenarioInterest, '', clTeeColor);
    end;

Cheers,

Raymond.
0
 

Author Comment

by:ugross
ID: 2530135
thanks for this profund answers rymond, will try them, thou i think there must be something more simple. cheers and thx
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Introduction The parallel port is a very commonly known port, it was widely used to connect a printer to the PC, if you look at the back of your computer, for those who don't have newer computers, there will be a port with 25 pins and a small print…
Creating an auto free TStringList The TStringList is a basic and frequently used object in Delphi. On many occasions, you may want to create a temporary list, process some items in the list and be done with the list. In such cases, you have to…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…

920 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now