Report Resource Work vs. Posted Work

[Dan Keen]

Each month, I have to generate reports from Project Server on total hours
worked for our Finance department. Before I can do that, I run a series of
checks to make sure that:
1. All resources entered their time.
2. The entered time was approved by the PM's.
3. All approved time was posted correctly to the project plans.

The process I've worked out is to use a Portfolio View that give me the
"posted" hours by resource by project, which I compare against the Resource
Assignment view that shows me the hours entered by the resource. Bouncing
between these two screens is incredibly tedious, so I'm trying to figure out
a way to compare the information in a single screen or, if necessary, a
Crystal Report that pulls the data from the Project Server.

Ideally, I'd like to see something like this:
Resouce #1
Project #1 Posted hours in Timesheet Posted hours in Project
plan
Project #2 Posted hours in Timesheet Posted hours in Project
plan
Resouce #2
Project #1 Posted hours in Timesheet Posted hours in Project
plan
Project #2 Posted hours in Timesheet Posted hours in Project
plan
etc.

If there's a problem, I'll need to drill down to the Task and Start/end
dates, so I'll need to have that detail available as well.

Would all of this come out of the MSP_WEB_WORK table, or do I need to look
somewhere else to get the data from the project plan?