Weekly Activity Reports

Weekly Activity Reports

I'm trying to set-up a report that would be a summary of last weeks activities (both tasks and events) and the coming weeks tasks that would be emailed out automatically Sunday night (I'm currently a free subscriber but would upgrade to Pro for this feature).

I'm having a couple of problems

1) I can't figure out how to create a single report that includes both the previous week and the upcoming week.  Is this possible?

2) I'm having trouble figuring out how to include both tasks and events on the same report, but in separate sections.

What I really want is 4 distinct sections.

1) Upcoming events for the week (meetings, conference calls and the like)
2) Tasks that are due this week (or are overdue)
3) Tasks that were marked as completed last week
4) Events that were on the calendar for the last week (again meetings and the like)

I can get pretty close to this by customizing the home page, but I'd like to add in a couple of additional columns like notes and have it available as a report that can be sent out to all users as a primer for a Monday morning meeting.  is this possible?