Calendar Style Report

Any ideas on how I might be able to create a report with a page for each
month, columns for each day, rows for each week and scheduled activities on
the appropriate date?
I have a db with rows for each activity and columns for various types of
dates, i.e, start, review, submit, etc.
TIA
deanIt's actually quite a lot of work...
You need to drive the report from a dataset that has generated calendar data
in it, and join your real data to this table on the date values. Then of
course you can group on month and week in the standard way.
There are two tricky parts. The first is generating the calendar data --
have you ever done this before? Here is an example -- not sure if this is
exactly the same as the one that I use, but it looks similar.
http://blogs.x2line.com/al/archive/2004/04/10/229.aspx
The second is a *bit* tricky, but mostly it is tedious: setting up the
columns for all the days in any given week. The information for each column
has a different offset (starting with 0 and going to 6) from the first day
of week.
Basically, it's a lot of SQL.
>L<
"Dean" <Dean@.discussions.microsoft.com> wrote in message
news:938ADD6C-2509-40C5-8339-AED5B2EC9224@.microsoft.com...
> Any ideas on how I might be able to create a report with a page for each
> month, columns for each day, rows for each week and scheduled activities
> on
> the appropriate date?
> I have a db with rows for each activity and columns for various types of
> dates, i.e, start, review, submit, etc.
> TIA
> dean