COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: Kiran Kandavalli on 14 Aug 2018 10:37:38 AM

Title: Scheduling - Report output should be Embedded in Email Body
Post by: Kiran Kandavalli on 14 Aug 2018 10:37:38 AM
Team,

I have a report in Cognos 11.0.11 - which need to be scheduled on Monday.

In the Report I have a List Report which shows 10 to 20 records. I wanted those records to be embedded in Email body instead of an attachment. Can anyone send me the steps for this please.

Thanks!
Kiran
Title: Re: Scheduling - Report output should be Embedded in Email Body
Post by: Cognos_Jan2017 on 14 Aug 2018 10:46:44 AM
Found this ...
http://cognosknowhow.blogspot.com/2014/05/how-to-embed-cognos-report-in-email.html

The link includes ...
It is very useful to have report in an email body, as the email can be well formatted, and users do not need to open attachment at all. It is even more appropriate for a small report. However, it is a little trick to have this function; the key is that

•the email body needs to be blank, and
•the attached report is HTML output.
Please see sample with simple report and event studio
=======================================
I do like " ... more Appropriate for a small report ... " above

Blank email body may be a negative.

As for HTML requirement, can understand that ... BUT my Company
LOVES Excel Reports.

Please let us know if the try the above link ... and your thoughts, recommendations.

Thank you, Bob
Title: Re: Scheduling - Report output should be Embedded in Email Body
Post by: Kiran Kandavalli on 15 Aug 2018 09:16:25 AM
Thanks its working fine.

The mistake I have done is "In Rows per Page I have mentioned  - 99999999999" and the Email scheduling is not working.

When I change it to 100 its working fine. Anyways, thanks for your help on this.
Title: Re: Scheduling - Report output should be Embedded in Email Body
Post by: Cognos_Jan2017 on 15 Aug 2018 10:11:48 AM
Glad it is working.

You are welcome, Bob