Home General
New Blog Posts: Merging Reports - Part 1 and Part 2

Sum?

edited March 2003 in General
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.

Comments

  • edited March 2003
    Richard,

    You can place a DBCalc component into the header band with your date and
    number labels. Set the DBCalc's LookAhead property to true.

    --
    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
This discussion has been closed.