You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

BIP Expense Report Approver

Received Response
edited Aug 14, 2019 7:21PM in Reporting and Analytics for ERP 3 comments


Looking to find the appropriate SQL that will give me the approver name for Expense Reports using BI Publisher


The goal of this report is to utilize bursting to send out a summary of expense reports related to various managers throughout the organization.

Example: A manager gets a weekly report showing all expenses of employees who reports to him/her.

One area where I am stuck is pulling in the approver of the expense report. I have attached the SQL that I currently have.

Any suggestions would be greatly appreciated!

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!