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.
<<image001.jpg>>
