Creating Reports with Assignment table Information

[JanK]

Using Project 2000
I have set up information that is collected at the Assignment Level in one of the Text fields. It shows properly in the Resource Usage and Task Usage views. I'd like to customize some of the reports to include this information (and ideally sort upon it) but can't find how to add the assigment level text fields into any of the reports. (Yes I know I can print the Resource Usage & Task Usage views, but those don't give me totals like I can get in a cross tab report)
I know I can export the data into Excel, but really would like to use some of the Project Reports

Any ideas?
Thank you in advance..
Jan

 

[Rod Gill]

Hi,

Your only hope is to use a VBA macro to copy the data to Task or resource
Text fields. The following code will do this for you.
If you already use Task.Text1 or Resource.Text1 for something, change the
Text field number to an unused field before running the code.

Sub Text1AssignmentToTask()
Dim T As Task
Dim A As Assignment
For Each T In ActiveProject.Tasks
If Not (T Is Nothing) Then
If T.Assignments.Count > 0 Then
T.Text1 = T.Assignments(1).Text1
End If
End If
Next T
End Sub

This code only copies Text1 from the first assignment on the task and
ignores the others. To copy data to Resource.Tax1 you have the problem that
a resource may be on 50 tasks, so unless all the data is the same, which
assignment do you copy from?

--
For VBA posts, please use the public.project.developer group.
For any version of Project use public.project
For any version of Project Server use public. project.server

Rod Gill
Project MVP
For Microsoft Project companion projects, best practices and Project VBA
development services
visit www.projectlearning.com/

Using Project 2000:
I have set up information that is collected at the Assignment Level in one

of the Text fields. It shows properly in the Resource Usage and Task Usage
views. I'd like to customize some of the reports to include this
information (and ideally sort upon it) but can't find how to add the
assigment level text fields into any of the reports. (Yes I know I can
print the Resource Usage & Task Usage views, but those don't give me totals
like I can get in a cross tab report)

 

[Mike Glen]

Hi Jan,

Welcome to this Microsoft Project newsgroup

I don't think that you can do this directly but you probably can get a vba
routine to help.

Please see FAQ Item: 37. Custom Fields in Tables and/or try posting on the
development newsgroup. Please see FAQ Item: 24. Project Newsgroups. FAQs,
companion products and other useful Project information can be seen at this
web address: http://www.mvps.org/project/.

Hope this helps - please let us know how you get on

Mike Glen
Project MVP