I’d suggest Cognos because it has the bursting capabilities which can generate a fraction of report data to different users according to their data right provided in a table, coupled with the event studio in Cognos, one can customize the email subject line and contents…