I have a manager asking for a report (repeatable) which shows all documents (In the approval workflow) that are not yet in the approved state.
How would I go about doing this?
are these all document that living in on Document Library?
If that's the case, simply build a view that looks at the Approval Workflow state.
Or, you could have a scheduled site workflow that queried that library, specifically for the state of the Approval Workflow.
If you want to go down to a deeper level, you could then also query the Workflow Tasks list for the specific tasks and their states.