I am creating a Sales report where I need to establish a feature like whenever my Sales are greater or lower than a threshold then automatically an email is sent to a manager or sales rep. Or If sales figure are lower or lesser than threshold, then flash or color change happens.Please suggest a way to establish both things in my report. Not sure if it can be done in Developer or Publisher.
Threshold values can be implemented in a few different ways. You could have an input box that the user types in the threshold and then use a variable in your expressions (for font color).
The thresholds can also be stored in a configuration file that becomes a datasource, read in at data load time. This allows an admin to change the values without having the user define them. Again the data would be read from the file and assigned to a variable used in an expression.
A similar expression can be used in an Alert (batch mode) OnPostReload. That will fire each time the document is reloaded. A custom email can be sent to a list of addresses or an expression that returns that list.
