I need to send a scheduled report via email , which is of type LIST, which uses the filter Manager is(dynamic) Me, how can I go about the scripting for this , I mean how can I send reports to users who are managers of other users??

[scottyharris]

Hi All, @I need to send a scheduled report via email , which is of type LIST, which uses the filter Manager is(dynamic) Me, how can I go about the scripting for this , I mean how can I send reports to users who are managers of other users??

Can anyone please help me with the script for this?

Thanks

valor

[Valor1]

I don't think you can do this with a scheduled report..

I'd probably write a custom scheduled job to query for the managers that need to look at the report, and send them a link to view the report instead of attaching to the email.

[scottyharris]

Hi Valor thanks for the quick reply,

Can you let me know the script for Schedule job solution??

[Community Alums]

Hello Harris,

There's no way today to manage this unfortunatly.

But we could imagine something intermediate which will require developments.

1/ Create a manager group

2/ Share the schedule report on this group

3/ Update the list of members on this group.

If you want to automatize make a business rules on group manager update that will

- Add the new manager to your manager group

- Remove the previous manager from your manager group.

[antin_s]

Hi Scotty,

The below should help you. Create a scheduled job to send all the manager's name one by one as input which can be used as filter inside the script.

Using Email Notifications as Custom Reports

Hope this helps. Mark the answer as correct/helpful based on impact.

Thanks

Antin