I have created a report that i'd like to burst to 14 recipients to show Staff Overtime Hours by month YTD.
When I run the report and select employee A from the prompt, it shows all of his staff that report to him, among 3 layers of the organization (employee, Supervisor, and Supervisors Supervisor)
When I run the report as a burst, and select the same employee from the prompt, it shows all of his staff that report to him.
The challenge i'm running into is that when I run the burst for all 14 employees, Employee A's report is only partially complete, and is missing a level to which he supervises.
Has anyone ever run into a similar issue?
I found out that the issue was due to a mis-type in the prompt filter. One of the filter criteria indicated that the Supervisor was equal to the prompt (=), rather than IN.
This was driving me crazy!