Generate report if data changes

Apologies if this is a FAQ, but I can't find any references to it:
Is it possible to regenerate a report if data changes? i.e. I have a status
column in one of my tables and would like to auto-generate a report (and
email it to a subscription list) if the contents of that column changes.Anythings possible, but "out of the box" I don't know of a feature that can
do this.
You'd probably need some kind of webserver that polled the database to check
for changes.
Once the change is found, you could then execute the report to run (via
scheduler).
"georges" <georges@.discussions.microsoft.com> wrote in message
news:05913C6B-81E7-4312-901D-3BB5A457026A@.microsoft.com...
> Apologies if this is a FAQ, but I can't find any references to it:
> Is it possible to regenerate a report if data changes? i.e. I have a
> status
> column in one of my tables and would like to auto-generate a report (and
> email it to a subscription list) if the contents of that column changes.
>|||*webservice, not webserver - typo.
"georges" <georges@.discussions.microsoft.com> wrote in message
news:05913C6B-81E7-4312-901D-3BB5A457026A@.microsoft.com...
> Apologies if this is a FAQ, but I can't find any references to it:
> Is it possible to regenerate a report if data changes? i.e. I have a
> status
> column in one of my tables and would like to auto-generate a report (and
> email it to a subscription list) if the contents of that column changes.
>|||As far as I know, I dont think any feature exists from reporting services but
can be done if you are using sql server 2005, notification services.
Amarnath, MCTS.
"georges" wrote:
> Apologies if this is a FAQ, but I can't find any references to it:
> Is it possible to regenerate a report if data changes? i.e. I have a status
> column in one of my tables and would like to auto-generate a report (and
> email it to a subscription list) if the contents of that column changes.
>