Send by email a dynamically filtered report to dynamic recipient

[Rosanero4Ever]

Hi all,

I created a simple report made up the following structure:

Manager - Finance Accounts -  Revenue

The report has an  initial prompt page for a mandatory filter for the Manager field.
I would like schedule this report in order to send automatically an email to each manager using the filter
For this, I created a table in my database which contains the relationship Manager/Email.
Is possible send automatically by email the filtered report to each manager?
I hope my explanation is clear.
Thank you very much in advance

[MFGF]

Hi all,

I created a simple report made up the following structure:

Manager - Finance Accounts -  Revenue

The report has an  initial prompt page for a mandatory filter for the Manager field.
I would like schedule this report in order to send automatically an email to each manager using the filter
For this, I created a table in my database which contains the relationship Manager/Email.
Is possible send automatically by email the filtered report to each manager?
I hope my explanation is clear.
Thank you very much in advance

Hi,

What you are describing here is possible using report bursting. You remove the manager prompt and add burst options to the report in Report Studio - the burst group would be the Manager and the burst key would be the Email address. Once you save the report, you can schedule the report and enable the "burst" checkbox.

Cheers!

MF.

[Rosanero4Ever]

Many thanks!
Is possible change dynamically the subject ?
At the end, is possible distinguish between "TO" recipients and "CC" recipients?
Thanks again

[Rosanero4Ever]

Can anybody advice me any hints?