Select and Report by Task level codes

P

PM Training 12

We have tagged certain tasks in multiple projects with task level codes. I'd
like to select all those tasks (in multiple projects) by the values in the
codes. Project Server 2003 has selections based on project level and resource
level criteria, but none by task level codes.

is it possible to select across projects using task level codes? I looked at
the OLAP extension available on the MS download page, but it doesn't
specifically state (or I don't understand) that it will add task level
selection to Project Server 2003.

Any ideas or suggestions? Thanks.
 
R

Ray McCoppin

There is not a way of doing this using Project Pro or PWA that I am aware of.
But I have written SQL queries to pull this type of information from the
Project Server database and display it using SQL Reporting Services or a ASP
page.

Hope this helps.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Resource Leveling 5
Master Project - Including only Select Tasks/Milestones from sub-p 1
Reporting Database - Transaction Level 1
leveling took too long (project server 2003) 0
SQL report code to print Gantt Chart 7
Propagating project level custom fields to assignment level - ANISSUE - please help. 3
Assigning Resources To Summary Level Tasks 2
Proposed Booking Type at the Task Level Doesn't Work? 3

Top