or use a TClientdataset which allows you to create calculated fields that can
be operated on in such a manner.
Dave
--- On Thu, 2/25/10, Nesler, Thomas J <tnes...@amfam.com> wrote:
From: Nesler, Thomas J <tnes...@amfam.com>
Subject: RE: [advanced_delphi] entry summation
To: advanced_delphi@yahoogroups.com
Date: Thursday, February 25, 2010, 7:23 AM
If you have the Enterprise version of Delphi, you will
find a tab called Decision cube which will do exactly what you are
looking for but if you have only the Pro version, you will need to do the
following:
1.
Create a temporary table to hold the Date, ID, Total amt
data. Whatever you want the columns and rows to be.
2.
You will need to read through the file and add the records to
your temp table. Based on what you are summing, you need to add the
Amount to the previous amount balance if there is a record already there.
3.
Finally, you can create a report that sorts the temporary table
and then prints it in the position you want.
If you want more detailed help you will need to explain what
your report columns and rows mean. Hopefully, this will get you thinking
in the right direction.
Tom Nesler
From:
advanced_delphi@ yahoogroups. com [mailto:advanced_ del...@yahoogrou ps.com] On
Behalf Of Ahmad $arhan ****
Sent: Sunday, February 07, 2010 7:38 AM
To: advanced_delphi@ yahoogroups. com; delphi
Subject: [advanced_delphi] entry summation
Hello
everybody
,
how are
you doing, hope you are all great,
I want to
ask you about something how to do it,
I have
accounts ENTRY table with many fields like (ac_bal, ac_id , ac_date, ...etc)
and I want to retrive the summation of each account in each month as table like
below
10-01 21-04 02-11-4 .....
jan
Feb
mar
.
.
.
etc
please advice me how to do it,
thanks.
