Bursting a report per mail and per directory

[shulk69]

Hi everyone,

I am bursting a report on Cognos Analytics.
I would like to burst my report per mail for several financial directions (I have a table which contains two fields : the financial directions code and its email adress), and burst the report per directory so that the other financial directions can see the report in their directory...

My idea was to burst with the "Automatic" mode on the following field :

Example :
Case
   When [Financial direction code] = '178106'
Then 'financial.direction@example.com'
Else [Financial direction code]
End

But an error occurs because the financial directions codes (for which I want the reports to be generated in the directories) aren't recognized as an email adress.

Would you have an idea of how bursting the same report on both ways ?

Many thanks in advance.

Kind regards,
Sébastien