Sum?
Hi,
i have a table with 2 field : date and number. i filter table with date (in
rb). how can is show sum number in above of row.
my table :
Date Number
---------------------------------
01/01/2003 100
01/02/2003 250
01/03/2003 410
01/04/2003 55
01/05/2003 100
for example when i say : Date<'01/03/2003' i want to see 350 (sum of
100+250).
i use ADO with SQL Server.
Best Regards.
i have a table with 2 field : date and number. i filter table with date (in
rb). how can is show sum number in above of row.
my table :
Date Number
---------------------------------
01/01/2003 100
01/02/2003 250
01/03/2003 410
01/04/2003 55
01/05/2003 100
for example when i say : Date<'01/03/2003' i want to see 350 (sum of
100+250).
i use ADO with SQL Server.
Best Regards.
This discussion has been closed.
Comments
You can place a DBCalc component into the header band with your date and
number labels. Set the DBCalc's LookAhead property to true.
--
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com