I'll advice to make use of "Database Views" instead of using temp table and updating same.
please mention which database you are using .eg. Sybase or Oracle or mssql . On Thu, Feb 25, 2010 at 8:53 PM, Nesler, Thomas J <tnes...@amfam.com> wrote: > > > 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...@yahoogroups.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. > > > > > > > -- Thanks, Prakash Shirodkar http://enote.in/sirodcar http://twitter.com/sirodcar http://www.linkedin.com/in/sirodcar http://www.facebook.com/prakash.shirodkar
