COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: dpccgf on 21 Jul 2017 04:32:52 PM

Title: Emailing a Full Report to all Emails Addresses in a Burst Table
Post by: dpccgf on 21 Jul 2017 04:32:52 PM
I have a report that bursts out fine via a burst table, however I have another report where the FULL report needs to go to everyone in the burst table. I know this should be an easy solution but for the life of me cannot figure out how to use the burst table to not burst, but serve as my distribution.  Basically burst it to every email address, but no burst key.  Just the whole report.  Any help would be appreciated!
Title: Re: Emailing a Full Report to all Emails Addresses in a Burst Table
Post by: CognosPaul on 21 Jul 2017 05:00:32 PM
Bursting is essentially another form of master/detail. Create a data item on both sides with the static value of 1, and link that.
Title: Re: Emailing a Full Report to all Emails Addresses in a Burst Table
Post by: gohabsgo on 27 Jul 2017 09:42:21 AM
We have this for some of our reports, just drag in the burst email field to the "To" field in an Agent email report task.