Yearly Calendar report with highlighted dates

[Tami Lamz]

I am trying to create a report that shows one full calendar year that has
highlighted dates for each customer I have in a database. Each customer has
work orders scheduled in the system on various dates. I want to create a
report for 2005 (and future years eventually) that shows all 12 months and
highlights the individual days that the customer has a work order scheduled
on. So, there would be one report for each customer with different dates
highlighted for each customer (corresponding to the work order dates). I
have been thinking about this for a few days and can't figure out how to
create a report with 12 months on it...Any ideas???

Thanks!!

 

[John Vinson]

I
have been thinking about this for a few days and can't figure out how to
create a report with 12 months on it...Any ideas???

I've done this once. It was a LOT of work - a report with 42
subreports, one for each day (I needed not just a highlight but a -
fortunately short - list of items each day). The report had a monster
query to populate each subreport with a given day's data.

In short - possible; not easy!

John W. Vinson[MVP]