Proof Approval Reporting Examples

[KellieGardner]

I'm looking for some examples of reports people are using for proof approvals. What columns are you displaying, anything fun i could be adding in text mode, etc. Our users want reporting but don't do a great job elaborating on what they want to see so hoping some creatives out there have ideas. 

I would also like to know which type of reports people are using for proof approvals and the reasoning. They each have their own limits on functionality they can display.

• Document
• Document Version
• Proof Approvals

[SarahWilkersonCA]

@Kurt_Jones 

I have a similar Document report and just want to add the column "Approvers and Dates" as you did.  I am not allowed to connect to atappstore to get the text mode.  Could you post the text mode for those that column here?

[Kurt_Jones]

Sarah, here's the textmode for that particular column:

displayname=Approvers and Dates
listdelimiter=<p>
listmethod=nested(proofApprovals).lists
textmode=true
type=iterate
valueexpression=IF(!ISBLANK({decisionDate}),CONCAT("• ",{approver}.{name}," - ",{decisionDate}),CONCAT("• ",{approver}.{name}))
valueformat=HTML

[SarahWilkersonCA]

Thank you so much @Kurt_Jones, but it's crazy, but it does not work for me on a Document Version report.  Not all of the proof variables are on the document object.  Document Version report uses the "current version" object...which isn't even in the API.  

In the column builder, "Current Version" object shows:

• Proof Creator ID
• Proof Deadline
• Proof Decision
• Proof ID
• Proof Name
• Proof Owner ID
• Proof Pages
• Proof Progress
• Proof Status

But doesn't offer Proof Approvals, Approver or Decision Date.  And text mode won't generate the fields not offered in the builder.  Strange.

I can get "Proof Approvals" to generate with text mode, but it's just jibberish...ex: [6309348f000d7a983a9d2740207ddf4e (ProofApproval-6309348f000d7a983a9d2740207ddf4e), 6309348f000d7a922b2e81bcbe46c77f (ProofApproval-....

I am wondering if Workfront is doing some database changes since they're working on the integration of proofs into Workfront???

I guess I will keep my Doc Version report without approvers.  Then have to have a second Proof Approvals report that is grouped by proof...I just rather have a doc report with the approvers in a collection.

Frustrating.  I really hope the new proof integration into Workfront will clean up the proof organization mess and help with reporting.  It's painful.

Thank you so much for all you've contributed to this thread!

[Kurt_Jones]

Sarah, send me an email and I'll send you a report of all my textmode on the report as it does work, but my report likely has different setup than yours, so it might help your review.  kurt.jones@jpmorgan.com

[JasonLe4]

Hi Kurt,

I know I'm way late to the party on this, but is there a way to add a column that displays the Workflow Templates for the proof the same way that it does in a Proof Approval report?

Thanks!

[Kurt_Jones]

Jason, the report above is a Document Version report type so there isn't a way to get to the workflow template used in the approval process.

[WhitUser]

Hi all

I feel like I might be in the right place for this query.. I have 6 project managers that send 100's of proofs for approvals to usually 3 completely variable approvers. My project managers would like a proof approval report that shows only the proofs that have been through the first three approvers and are now 'back with them' as the final approver, they are not interested in ones that are still being reviewed by 1,2 or 3. 
Approver1
Approver2
Approver3
Approver 4 (Project manger). I just want to see lines that are at this stage

So its a filter by final approval stage that I am trying to achieve but I cant seem to do this - any tips would be a game changer for us!
Thank you in adavance