Is it possible to schedule a report to run when data in a MS SQL table changes?

I see that you can run a report when an "Event" is triggered, but I don't see how to trigger an event based on a table change. When we were talking to the sales guys when buying this product they indicated that it was possible.

Anyone doing this? We have a report based on a table generated within MS SQL 2000. I would like the report to automatically run when the table is updated.

Any ideas?