Find Resources with missing Timesheets

P

Pete Smith

Hi,

what is the easiest approach to find out, which resources have missing
timesheets = have not reported actuals for the current period?

Thanks in advance
Pete
 
E

ecc1213

we run an OLAB cube view to pull hours for the date range,
then use the following Access SQL query to see what managers have not
APPROVED time submitted within the dates prompted (it asks the dates
twice, don't know why)
It is pretty rinky-dink, but does the job
The between statment appears to look from 12:00 AM on start to 12:00 AM
on end, so you actually have to put in the next day

SELECT DISTINCT dbo_MSP_WEB_RESOURCES_1.RES_NAME,
dbo_MSP_WEB_RESOURCES.RES_NAME
FROM (dbo_MSP_WEB_ASSIGNMENTS INNER JOIN dbo_MSP_WEB_RESOURCES AS
dbo_MSP_WEB_RESOURCES_1 ON dbo_MSP_WEB_ASSIGNMENTS.WRES_ID_MGR =
dbo_MSP_WEB_RESOURCES_1.WRES_ID) INNER JOIN dbo_MSP_WEB_RESOURCES ON
dbo_MSP_WEB_ASSIGNMENTS.WRES_ID = dbo_MSP_WEB_RESOURCES.WRES_ID
WHERE (((dbo_MSP_WEB_ASSIGNMENTS.WASSN_ACTUALS_PENDING)=1) AND
((dbo_MSP_WEB_ASSIGNMENTS.WASSN_SEND_UPDATE_DATE) Between [Start:] And
[End:]))
ORDER BY dbo_MSP_WEB_RESOURCES_1.RES_NAME;
 
Top