BIP Expense Report Approver
Summary
Looking to find the appropriate SQL that will give me the approver name for Expense Reports using BI PublisherContent
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!
2