We have a report that displays Sales Amout by Region.
We need ability to send the Alert/Web report to the Regional Sales Manager when the Sales fall below perticular threshold.
We have a condition in our query that works just fine for that purpose. And the Information Broadcasting works fine as well.
Issue is we have over 150 Regional Sales Manager and I do not wish to create 150 Information Broadcasting settings to be run nightly.
Is there any other options to achieve this functionality.