triggering a BO report based on a database table update
I have a table having columns like Country, Start Date, End Date etc. And I have a webi report having same fields set as prompts. The table has one more column called "Status".
So the requirement is whenever the table has a new row inserted, it takes the values of prompts from the table and triggers the webi report.
Once the report is generated, the status column of the table is updated with "generated" for that record.
Is it possible and how?
Thanks in advance,