Reporting on approvals

sguthrie · ‎01-06-2016

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 · ‎01-07-2016

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.

View solution in original post

sguthrie · ‎01-07-2016

Approval for.Assignment group is blank for me. The group is assigned in the Workflow-Activity Properties: Approval-User. This group is assigned to receive the approval emails.

Raju Koyagura · ‎01-07-2016

In workflow activity even though you used approval group, it won't create a single approval record for that group. Instead it creates n number of records based on the group members and each member can get one approval record.

Sent from my iPhone