Project 2007 Enterprise Custom Field Best Practice

[newsgrp]

I have a need for a few custom fields that are greater than 255 bytes. What
is the best practice to load and save that data. It also needs to be
available for SQL Reporting.

Should I create a table in the reporting database to hold the data and write
code in the Project 2007 app? Is there a way to enter data from PWA?
This data will be required on all projects, even those without a sharepoint
site.

Any feedback would be appreciated.

 

[Marc Soester [MVP]]

Yo ucan create Proejct custom fields and associate a lookup table to the
custom field. This list of the lookup table can be very long. A PM would
choose the value using a drop down window.

If you want to create a text field that you want to use for Project
Description for example, I would only do that using a Workspace. Proejct
Server does not give you an option for a rich text - lots of text - custom
field and that is also not the purpose of it. You can of course custom
develop around Project Server, but I would think that it is easier to use the
project workspace.
Any custom field that you create can be reported agiainst the reporting
database.
Hope this helps