Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

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

Summary

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

Content

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.

Register

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