COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: rajasekharbathala on 30 Jun 2014 03:22:57 AM

Title: Different emails are getting while bursting with page break
Post by: rajasekharbathala on 30 Jun 2014 03:22:57 AM
Hi,

Could you please some one help on the following requirement.

Employee EID     Project Name
abc@gdc.com      PQR
edf@gdc.com       JQK
abc@gdc.com      BRS
irj@gdc.com         OPQ

i put page break on Project Name and i used single query for recipient and burst information. if i burst the report the user  abc is getting two different emails, one email for PQR project and another for BRS Project.

i am expecting the user abc should get an email which has PQR and BRS Projects information in a single pdf file.

Environment: Cognos 10.1.1 and Oracle 10g

Thanks in adavance..

thanks,
Title: Re: Different emails are getting while bursting with page break
Post by: Ammus1234 on 30 Jun 2014 04:13:38 AM
What is your burst group?
Title: Re: Different emails are getting while bursting with page break
Post by: raj_aries81 on 30 Jun 2014 04:23:27 AM
Did you try grouping on email address....and then bursting, pbly it could work

Regards
Raj
Title: Re: Different emails are getting while bursting with page break
Post by: rajasekharbathala on 30 Jun 2014 04:25:19 AM
Hi,

Thank you for your reply!!

i specified burst group as DataItem1 which holds abc, edf and irj etc user name values.

I tried with keeping Project Name also in the Burst Groups but no use.

thanks,
Title: Re: Different emails are getting while bursting with page break
Post by: rajasekharbathala on 30 Jun 2014 04:28:06 AM
Hi Raj,

I tried that also but it did not work as expected..

could you please help on this requirement.

thanks