Creating Event on SQL report

[anjidwh.cognos]

Hi ,

I have a report say "Bank Acc Report'". This is generated on bais of SQL query. And the report contains the following fields.

1. Client Name-------------> Name of client
2. Bank Name-------------->Name of the bank
3.Changed Time----------->Date
4. Changed By------------->(Name)
5. Changed Type----------->(Update)
6. Is_Acc_Number---------->(Yes/No)

Now i have to create an event whenever the account number is changed to the client and send a email to the respective client or specific group.

Does Metadata required to create event condition and event key. If it is required, on which basis i have to check whether the acc number is changed or not.

Can anybody please help me to sort out this!!! Appreciate your help.

Thanks
RK