Proof Approval Reporting Examples

[KellieGWAB]

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

[Kurt_Jones]

This is one we just created as we start to use Proof, there is some textmode with it.  Happy to share how its made.

[KellieGWAB]

I like this! Which type of report did you use to build this? I would love more on how it was built especially text mode components. 

[Stacey_Robertson]

This looks great, I'd be interested in the text mode as well.

[Kurt_Jones]

Send me email at kurt.jones@jpmorgan.com and I'll send you info to make it

[Sbhuta]

Hi Kurt,

Can I get the info to make this? 

Also, is there a way to pull a proof report to just see proofs, where I am the reviewer? 

[Kurt_Jones]

Sbhuta,

Follow the instructions in the green accepted answer box above that Doug outlined, that process will help install the report into your Workfront domain so you have it.  If you have trouble with that then send me an email and I'll send a doc of instruction.

The report I provided above was for a use-case for folks that needed to see proofs across their system in various stages to be able to monitor and wanted to see a visual of the proof.  In this case, a document version report allows the thumbnail field (proof report not so much). The report also has a lot of textmode.

I cant think of a way to filter proofs by the reviewer, the reporting folks on the approver and approval stages within the API.

[lynnb27003914]

This looks like exactly what I need! Are you still willing and able to share how it is made?

[Kurt_Jones]

Email me at kurt.jones@jpmorgan.com and I'll send you info to make it.

[CoffeeMan_SFF]

I know this is several months old, but I would also love to see the text mode behind this Proofing Report. Can I shoot you an email?

[Arnab4]

hey ,

can you tell me which filter should you use to make this report?

[Frank322]

This looks great. Are you able to share the text mode for pulling in the document thumbnail? I have tried to replicate this column and am struggling with it. Please let me know. I can email you if that is preferred.
Thanks!

[CathyKe1]

You kindly shared the text mode with me - thank you! I love the column "Approvers and Dates."

I'm trying to implement that same idea in an existing Proof Approvals report rather than Document Version report (like yours), but I am not getting it to work.

Do you know if it's possible to list the approvers and dates in that type of report? Hoping I'm just overlooking something simple.

Thanks, Cathy

[Doug_Den_Hoed__AtAppStore]

Nice report, Kurt!

Given the continuing interest from other folks, if you'd like to wrap it into a deployable Package so others can easily install it (as we've done with the DRA@WF Cleanup Dashboard, Workfront Cleanup Dashboard, User Initials, etc.), I'd be happy do do so with you sometime.

Regards,

Doug

[Kurt_Jones]

Hi Doug,

Happy to work within your schedule over the next few weeks when you have time and we can do it.  Hopefully you still have my email for our earlier work, send invite and we'll go from there.  Thanks for the offer.

[Arnab4]

Can any one suggest me which filter i can use for show only open projects proofs in this report?

[Kurt_Jones]

Arnab, there isn't a way (that I'm aware of) or the ability in the Workfront API to connect project status within a Document Version or Proof Approval report type.  There are no available collection or reference fields to help make a relevant connection to the project status field...its simply a limitation of the reporting.  For my report and the Proof Approval report those report types are built to focus on the document/proof and its stages.

[Frank322]

Hi Arnab,

I ran across the following text mode code in another post that will allow for filtering a proof approval report by projects in current status. Hopefully this helps.

EXISTS:a:$$OBJCODE=DOCU
EXISTS:a:project:status=CUR
EXISTS:a:project:status_Mod=in
EXISTS:a:versions:ID=FIELD:documentVersionID

[Arnab4]

i used this filter its not working on my report, can you send me your report and filters screenshot on arnab.laha2018@gmail.com mail id?

[Arnab4]

now i am trying to add a new tab called project status in document type report where i need to show only current and onhold project proofs in my report , can you guide me which filter and column i need to use?

[Kurt_Jones]

Arnab, based on update from Frank322 above, you should be able to change the filter in my report I provided you to look like the below:

EXISTS:1:$$OBJCODE=DOCU
EXISTS:1:ID=FIELD:documentID
EXISTS:1:project:status=CUR OHN
EXISTS:1:project:status_Mod=in
isCurrentVersion=true
isCurrentVersion_Mod=eq
proofedByUserID_Mod=notblank

My report is a Document Version report and it did work for me in my testing and should show proofs on projects that are still current.  As Frank322 noted, what he provided above works on a Proof Approval report as well.