report between dates

rbuser

hi


i need to samething like this in a report between two date
example:between 01-01-2001 and 31-12-2001

Date Description value
Amount paid
----------------------------------------------------------------------------
-----
Value before 01-01-2001 is ------------->>
100,000.00 ---------------> how can i put this in my report
----------------------------------------------------------------------------
-----
01-01-2001 xxxxxxxxxxxxxxxxxxxx 99,999.00
199,999.00
05-01-2001 xxxxxxxxxxxxxxxxxxxx 100,000.00
299,999.00
----------------------------------------------------------------------------
----
total value 100,000.00
Total 299,999.00


how can i put the value before the two dates and sum de value whith the
detail value;


thanks

anyone help me please

digitalmetaphors

If the data records are ordered by date, the you can create a group on a
custom field such as a label. Then you can use a DBCalc in the group footer
band to print the sum of the amount paid. To reset the dbCalc, set its
reset group property to the group. Then use another dbCalc in the report
summary band and it will sum all of the amount paids for all records printed
in the report.


Cheers,

Jim Bennett
Digital Metaphors