Project 2003 Server - Skills Reporting

M

mark_h

Hi,

I have recently completed an install of Project 2003 Server, and have
implemented several custom mulitvalue enterprise resource outline codes
to hold information such as skillset, qualifcations, languages etc.
Everything works great, and I am able to use team builder just as
described to search for resources based on availability combined with
these multivalue fields..

The other day however, I was asked to produce a report showing all the
various qualifications that we have in the organisation, by staff
member.

I've scratched around for days and can't find anything except for
references to SQL reporting services for anything that isn't possible
in native project. Before I embark on that I just want to be sure that
this is the only way. The multi-value fields are stored within SQL as a
numerical value, and there doesn't seem to be a corresponding table to
translate it back to text (I'm sure there must be somewhere though!). I
have manually worked out which mulitvalue codes relate to which
qualifications, and with this info am able to create a report in Excel
using an ODBC connection. Though it works fine, it's an ugly solution,
and one which I wouldn't want to inherit myself.

I don't want to leave it like this and I'm amazed that although using
custom mv enterprise resource fields are a microsoft recommended way of
implementing skills based resource selection in Project 2003 server,
there doesn't seem to be any way of reporting on what's in there once
you've set it all up.

Any ideas? To start with, I need a simple report, by resource, listing
their corresponding qualifications (from the ent resource outline mv
code) on the right.
 
M

Mike Glen

Hi Mark,

Try posting on the server newsgroup as this one is closing down. 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
 

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

Top