JimW --
No, there is no way to prevent this. Therefore, this is a training and
performance issue with your project managers. Hope this helps.
- Show quoted text -
if all your Enterprize resources have a resource group
you can make a SQL Query to get the local resource
it should be like this
SELECT MSP_VIEW_PROJ_TASKS_STD.ProjectUniqueID,
MSP_VIEW_PROJ_PROJECTS_ENT.ProjectEnterpriseName
FROM MSP_VIEW_PROJ_TASKS_STD INNER JOIN
MSP_VIEW_PROJ_PROJECTS_ENT ON
MSP_VIEW_PROJ_TASKS_STD.WPROJ_ID = MSP_VIEW_PROJ_PROJECTS_ENT.WPROJ_ID
INNER JOIN
MSP_VIEW_PROJ_PROJECTS_STD ON
MSP_VIEW_PROJ_PROJECTS_ENT.WPROJ_ID =
MSP_VIEW_PROJ_PROJECTS_STD.WPROJ_ID
WHERE (MSP_VIEW_PROJ_TASKS_STD.TaskResourceGroup LIKE '') AND
(MSP_VIEW_PROJ_TASKS_STD.TaskResourceNames NOT LIKE '') AND
(MSP_VIEW_PROJ_TASKS_STD.TaskResourcePhonetics LIKE '')
GROUP BY MSP_VIEW_PROJ_TASKS_STD.ProjectUniqueID,
MSP_VIEW_PROJ_PROJECTS_ENT.ProjectEnterpriseName