Reporting help: Text mode pulling fields from Document Approval report into the Document report

[ElizabethP2]

I'm trying to pull the Document Approval>>Request Date field from the Document Approval report into a Document report. I've tried copying and pasting the text mode from the Document Approval report to the Document report, but the values are coming up blank (see below for text mode). Does anyone have any advice here?

descriptionkey=requestdate

displayname=Approval Request Date

linkedname=direct

namekey=requestDate

querysort=requestDate

textmode=true

valuefield=requestDate

valueformat=atDate

width=85

[skyehansen]

hi Elizabeth, for every document there can be more than one approval. Workfront calls this a one-to-many relationship, and because there can be more than one, you will be unable to just copy textmode from an approval report to a document report. Hope that makes sense so far.

My advice is that you look up "referencing a collection" in a report and see if you can make those instructions work for you.