Expand my Community achievements bar.

Latest Community Ideas Review is Out: Discover What’s New and What to Expect!
SOLVED

Proof approval report with category name

Avatar

Level 5

Hello!

 

I need to create a proof approval report that includes a project Category column. I've tried every single option on the report and none of them work. Anyone know how to do this?

 

Thanks!

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hi Justin,

 

Assuming that "project category" is a custom field that is attached to projects, the following text mode view in a proof approval report should do the trick:

 

displayname=Project Category
linkedname=documentVersion
namekey=view.relatedcolumn
namekeyargkey.0=documentVersion
namekeyargkey.1=document
namekeyargkey.2=project
namekeyargkey.3=DE:Project Category
textmode=true
valuefield=documentVersion:document:project:DE:Project Category
valueformat=HTML

 

Best Regards,

Rich.

View solution in original post

2 Replies

Avatar

Correct answer by
Community Advisor

Hi Justin,

 

Assuming that "project category" is a custom field that is attached to projects, the following text mode view in a proof approval report should do the trick:

 

displayname=Project Category
linkedname=documentVersion
namekey=view.relatedcolumn
namekeyargkey.0=documentVersion
namekeyargkey.1=document
namekeyargkey.2=project
namekeyargkey.3=DE:Project Category
textmode=true
valuefield=documentVersion:document:project:DE:Project Category
valueformat=HTML

 

Best Regards,

Rich.