Reporting on approvals

[sguthrie]

I have a Request item with approvers in the Workflow.   I want to report on who approved/rejected each step.   I tried from the Approval (sysapproval_approver table) but can't find how to dot walk to the item.   Is this possible?   ~Thanks.

[Raju Koyagura]

Create report like below, I am not sure is the same thing you are looking for....

[sguthrie]

Perfect!   Thanks.   Each approval has a group assigned to it.   The last field I need is this group.   Is this possible?   Also, is there a way to see table relationships to help me with the dot walking?   Thanks   for your help.

[Ajai S Nair]

Hi Sherri,

You can try with the report Raju mentioned above. If you want to get the complete details of approvals for a single request item then give the filter as Approval for is <RITM number>.

[Raju Koyagura · Accepted solution]

Yes, you can add assignment group as well. Dot walk can be done for a reference field, if you select refernce field like "Approval for" in the available section you will find   "+" symbol beside to the available section. Just click on that '+' symbol to get that specific table fields.

Please mark it correct answer, if this answer your question.