Year to Date Totals

rbuser

I am trying to create a report which will display year to date totals in the
summary.

I have a report that now shows all orders that have been completed between
two dates. I would like to add a summary at the bottom of the report that
will show the total # of completed orders year to date. Can anyone help or
point me in the right direction?

Thanks,
Todd St. Pierre
todd@devontitle.com

nardmoseley

From what you describe, I think you need a separate summary query that
calculates the YTD totals.

1. create a summary query

Select Count(*) as YTDCount
from orders
where orders.OrderDate >= StartOfYear and
orders.OrderDate <= EndOfYear

2. add a summary band to the report

Use DBText components in the summary band to print the summary total.



--
Nard Moseley
Digital Metaphors Corporation
www.digital-metaphors.com