How to filter Proof Approval Type report by using Project Custom fields?

Question

Sven-iX · Answer

It seems in reporting you cannot traverse from a document version to parent objects beyond the document:

The hierarchy is

Say you have project field "customProjectField"

You'll need to create a calculated field at the document, and make it show the project custom field:

docuCustomField = {project}.{DE:customProjectField}

Then in your report you can create a column

valuefield=document:docuCustomField
valueformat=HTML
displayname=Field showing projectCustomField
linkedname=direct
namekey=document:docuCustomField

Sign up