RBS into MS Excel via MS Query

[Vin]

Hi Jack

I'm trying to run an MS Query so that I can pull resource data from the
Project Server 2003 into an Excel 2007 worksheet.

Could you tell me how to pull the RBS data for a resource onto the XLS?

At the mo, I have...
SELECT dbo.MSP_WEB_ASSIGNMENTS.TASK_NAME AS [Task Name],
dbo.MSP_WEB_PROJECTS.PROJ_NAME AS Project,
dbo.MSP_VIEW_PROJ_ASSN_TP_BY_DAY.AssignmentTimeStart,
dbo.MSP_VIEW_PROJ_ASSN_TP_BY_DAY.AssignmentTimeFinish,
dbo.MSP_VIEW_PROJ_ASSN_TP_BY_DAY.AssignmentTimeWork /
420000 AS [Work], dbo.MSP_WEB_RESOURCES.RES_NAME
FROM dbo.MSP_VIEW_PROJ_ASSN_TP_BY_DAY INNER JOIN
dbo.MSP_WEB_ASSIGNMENTS ON
dbo.MSP_VIEW_PROJ_ASSN_TP_BY_DAY.AssignmentUniqueID =
dbo.MSP_WEB_ASSIGNMENTS.ASSN_UID AND
dbo.MSP_VIEW_PROJ_ASSN_TP_BY_DAY.WPROJ_ID =
dbo.MSP_WEB_ASSIGNMENTS.WPROJ_ID INNER JOIN
dbo.MSP_WEB_PROJECTS ON
dbo.MSP_VIEW_PROJ_ASSN_TP_BY_DAY.WPROJ_ID = dbo.MSP_WEB_PROJECTS.WPROJ_ID
INNER JOIN
dbo.MSP_WEB_RESOURCES ON
dbo.MSP_WEB_ASSIGNMENTS.WRES_ID = dbo.MSP_WEB_RESOURCES.WRES_ID

Hope you can help!
Thanks
Vincent

 

[Mike Glen]

Hi Vin,

Try posting on the microsoft.public.project.server or the developer
newsgroup. Please see FAQ Item: 24. Project Newsgroups. FAQs, companion
products and other useful Project information can be seen at this web
address: http://project.mvps.org/faqs.htm

Mike Glen
Project MVP