Report with Approval and Variables for Requested Items.

alona3
Tera Contributor

I want to create a Report with Approval and Variables together for Requested Items. 

Approvals details should be some fields from sysapproval_approver table. Requested Item details sc_req_item and the Variables details including the Question and Value provided by User.

5 REPLIES 5

Mark Manders
Mega Patron

You can't report on this directly. It will need a database view to connect all required tables together.


Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark

Can you help me how to create database view for this?

Mark Manders
Mega Patron

https://www.youtube.com/watch?v=_JY462TmXxU


Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark

thank you. i will check on this.