MySQL Forums
Forum List  »  Knowledge Base

create report
Posted by: Waseem Manzur
Date: May 15, 2009 12:40PM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
create report
5393
May 15, 2009 12:40PM
2260
May 18, 2009 09:54AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.