Project report with a custom field from a User?

[MegFl]

Hi,

I want to create a project report of all the projects with the requestor and their division.  The division is part of a custom field under users.  I can see it in a user report but not in a project report.  

This is the text from the user report.

displayname=
linkedname=direct
namekey=Division
querysort=DE:Division
valuefield=Division
valueformat=customDataLabelsAsString

Any help much apprecited.

[William--]

If Division is a field on your User form, and you are wanting to display the Division of the user who submitted the original request before it was converted to a project, this should work: 

displayname=Requester Division
linkedname=convertedOpTask
textmode=true
valuefield=convertedOpTask:owner:DE:Division
valueformat=HTML

[MegFl]

That only sort of worked.  We often have projects where the requestor is added or changed after the request has been converted.

I'm looking for using the requestor assigned in workload balancer or on the task tab.

I've been trying something like this but it hasn't worked.

I can see the information on a user report but can't translate it to a project report.

displayname=Requester Division
listdelimiter=/
textmode=true
type=iterate
valueexpression=IF(CONTAINS("Requestor / Client",{DE:Division}.{DE:Division}))
valueformat=HTML