Creating a Report based on logged in User

[Jags5]

I want to create a report where it take the user id and returns all the employees reporting to the user

Based on User => ReportsTo

And then I want to display all the incidents created by those users/ Assigned To those users, in a pie chart.

I tried adding Database View but no use.

Let me know if you solved similar problem.

[Allen Andreas]

Hello,

Clicking the pie chart isn't going to be able to open up another report for them to access..you'd have to create another report for them to use (and they access it separately) which instead of just being opened_by.manager you'd dot-walk yet again to opened_by.manager.manager

Thanks!

[Jags5]

Thanks Allan. I figured out how it is setup.

I think drill down would be possible when we add custom columns to the table and store reports to and reports to's reports-to when each row is created.

But that will amount to customization..