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.
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.