COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Bark on 12 Dec 2012 04:18:25 AM

Title: Send email from report
Post by: Bark on 12 Dec 2012 04:18:25 AM
Hi gurus,

I've been trying this for days and it looks like I cannot find any solution, hopefully you can help me.

A bit of background: There is a master report, from a cube, kind of a dashboard, where the users filters and drills (up/down); There is a table with the numbers. Currently those numbers have a drill-through with all the parameters ( 8 ) pointing to a relational report with all the detail.

Well, I want the detail report to be sent by email by default to a recipient input by a parameter. I have tried with drill-thru but there is no option for sending it by email. I have also thought about creating an agent that emails the report but I couldn't figure out how to run the agent from the report.

Any ideas?

Many thanks.

Regards,

Bark
Title: Re: Send email from report
Post by: AussiePete2011 on 12 Dec 2012 03:02:00 PM
Hi there,

You could consider using HTML items to send the report with the data you want.
Found this as an example on another forum
http://stackoverflow.com/questions/5168546/how-do-i-build-a-mailto-hyperlink-column-in-a-cognos-report

It's something to think about and there may be javascript options as well.

Cheers
AussiePete
Title: Re: Send email from report
Post by: Bark on 14 Dec 2012 03:26:42 AM
Thanks for the link, AussiePete2011.

I will consider that option although it will imply to put the whole report into (or surrounded) by an HTML Item...

Any other ideas using Cognos email functionallity?

Regards,

Bark