create report

[Waseem Manzur]

Hello

i need to create report for all the salespeople in the database. there are many tables involved mainly tasks, calls, meetings, visits, orders etc. i want to create a report starting from year to today with a break down by week/month/year with a count of each activity for each rep in each week and month

something like

Rep - Week# - Month Name - Year - Tasks - Calls - Meetings - Orders Sold
========================================================================
A - Week1 - Jan - 2009 - 2 - 3 - 0/Null - 7
B - Week1 - Jan - 2009 - 0/null - 2 - 0/Null - 0/null
C - Week1 - Jan - 2009 - 0/null - 8 - 0/Null - 5
A - Week2 - Jan - 2009 - 2 - 3 - 0/Null - 7
B - Week2 - Jan - 2009 - 0/null - 2 - 0/Null - 0/null
C - Week2 - Jan - 2009 - 0/null - 8 - 0/Null - 5
A - Week3 - Jan - 2009 - 2 - 3 - 0/Null - 7
B - Week3 - Jan - 2009 - 0/null - 2 - 0/Null - 0/null
C - Week3 - Jan - 2009 - 0/null - 8 - 0/Null - 5


above is just a sample and layout how i want it. there are about 8-9 tables involved. i've been able to do the break down on 1 table only for only 1 rep. as soon as i link it to the users table and other tables results become invalid and numbers returned are wrong. is there any way i can accomplish this?

any help would be greatly appreciated.

Thanks in advance.