How to Dot-Walk from sysapproval_approver to sc_req_item?

[gk24]

I would like to use the Report Builder (in London) to generate a more detailed report for users regarding their approvals.

I am able to get everything I need from the sc_req_item table but need to dot-walk to the approval table to obtain the pending requests for the specified user. Would appreciate any advise and thanks in advance! 

I've read that 1-M relationship between approver and req_item means it's not doable but there is only one approver on the form.

[Slawek_Radziewi]

You need to start from sysapproval_approver table and dot walk to requested item.

[gk24]

For some reason, fields I dot-walk to don't show on the report when I try this 😕

[Prateek kumar]

You have to select Show Related Fields at the bottom of the list first.

https://docs.servicenow.com/bundle/orlando-platform-user-interface/page/use/navigation/reference/dot...

Please mark my response as correct answer and helpful if it helped solved your question.
-Best Regards
Prateek kumar

[guided by books]

the "Approval for" field on the Approvals table stores the ID of the sc_req_item table, does that help?