Custom Proofing Approval Report

Hi WF Community, I want to create a proofing approval report with the following characteristics and don't know where to start. I've tried a few of my old tricks but they don't seem to work with this new report type. Any ideas on how I can accomplish these goals?

View (columns needed):

-Proof Name

-Proof Owner

-Proof Deadline Time Stamp

-Project/Task/Issue Name the Proof was generated in

-Link to the WF Project/Task/Issue the Proof was generated in (bonus if you can make the column above a clickable link and we can remove this column)

-Stage the Proof is In

-Comments Added when the Proof was Generated

Grouping:

-By Project Category (aka Project Type)

Filters:

-Only show proofs where the proof creator's home team ID = user's home team ID.

Additional Formatting:

-Conditional Red Text, Bold, Red Background on entire row if proof deadline is within an hour or past due

-Conditional Red Text, Bold, Red Background on entire row if document name contains "urgent" Christopher Wirth Stream Companies