Scheduled Reports with Dynamic Prompt Values and Recipients

[rocket21]

Not sure which forum to post this.

Business Challenge:  E-mail variations of an Excel report to different users.

Ideally, I'd like to set up a table in the source database that has a column for the parameter value and corresponding e-mail address, then have Cognos push the reports to the specified e-mail address with the specified parameters once a week.

Is this possible, and if so, what is the best way?  There would be over 100 parameter values/e-mail address to maintain, so being able to maintain a table of values would be a lot better (and have better business/audit controls) than manually creating, scheduling, and editing jobs.

[Lynn]

This is a similar question with a response that might be useful.

http://www.cognoise.com/index.php/topic,26147.msg83100.html#msg83100

[rocket21]

I looked into bursting, but the report is complex with crosstabs, which don't appear to work with bursting.