How do I add a custom column to a resource report?

[Rich in Westminster]

I am using job numbers inserted into a custom column (text1) to keep my task
names associated with the proper timetracking number. When I print a resource
report, the end user does not see the job number for the task. I would like
to add the custom text column to the report, but the best I have been able to
do so far is to use it in the sort.

 

[JulieD]

Hi

it probably would have helped if you had let us know which resource report
.... but basically, if you choose the report under the custom category and
click EDIT, most of the reports are based on a table ... see what table it
is, then go and either add your column into that table or create a new table
with your column in it and then edit the report to use this table instead
(it is actually an even better idea to copy the report and use this copy
with your new table as its source so that you don't "mess up" the existing
reports).

 

[JulieS]

Hi Rich,

To add to JulieD's suggestion, if you added the [Text1] column to a task
view, depending upon which resource report you are printing, the data may
still not appear. There are three different sets of custom fields, one for
tasks, one for assignments, and one for resources. So if you added the
data to the task [Text1] field and print a report that is based upon the
resource table, even if you include the [Text1] field, you will not see your
data as you are adding the [Text1] field from the resource side.

Take a look at FAQ #37 at:
http://www.mvps.org/project/faqs.htm

for some additional information and a piece of VBA code to transfer data
from a text field to an assignment field.

Hope this helps. Let us know how you get along.

Julie