COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => COGNOS Connection => Topic started by: nanquan on 18 Oct 2007 03:35:51 PM

Title: send excel sheet report as attachment
Post by: nanquan on 18 Oct 2007 03:35:51 PM
Hi
We are using reportnet 7 1.1 , I was required  to schedule a report
with Excel 2000 Single Sheet as the output format to be run at certain time
and send the spread sheet as an attachment of email to our business user.
  When people received  the email  and click  on the link of the attachment it always lead them to the link like http://localhost:7070/crn/cgi-bin/cognos.cgi?  not to  real  report output url.

Any idea how to resolve this.

Thanks

Title: Re: send excel sheet report as attachment
Post by: rockytopmark on 29 Oct 2007 09:20:21 AM
When setting up a scheduled execution, with email delivery, you can specify to send just a link, or actually attach the output file (or both).  Make sure you have selected to attach the output file, if the email should contain the excel worksheet itself, asan attachment.

The Link, however, if selected to be included in the email, should redirect the browser to the saved version of the last execution, assuming one was saved.  If the link is not performing this correctly, then you indeed have an issue... one that I can't help with, unfortunately.  I would contact Cognos Support for that.