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
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.
May 15, 2009 12:40PM
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.