need to create report for sc_request and need to check who approved for the request.

[Vani14]

we need to create the report for sc_request and need to check the approver for the requests could you please let us know how can i achieve this.

[praneeth7]

Hello @Vani14 

You can create a database view for sc_request and sysapproval_approver table. it will help you to create a report with you approved the requests.

If you find the useful Please mark my answer Helpful & Accepted solution,

Thank you

Praneeth

[Vani14]

@praneeth7  i have create data base view trying add condition for that could you please help me

[praneeth7 · Accepted solution]

Step 1: create database view with this condition.

Step 2: Create a report using this date base view and confugure the column as per your requirement in report.

eg: 

If you find the useful Please mark my answer Helpful & Accepted solution,

Thank you

Praneeth