COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Topic started by: koolbachi on 12 Jun 2007 09:41:13 AM

Title: Excel output through is email not genreted
Post by: koolbachi on 12 Jun 2007 09:41:13 AM
Hi,

I have two problems regarding the excel output :

1. When i schedule the report and select the option send through email in excel format
  I am not able open in excel and the ourput comes in html format.

2 .  When i busrt the report same problem asrise for the exel output.

But when i run in browser able to generate output in Excel as well,
Could please recommend the reason behind it.

Thanks
gops

Title: Re: Excel output through is email not genreted
Post by: goose on 12 Jun 2007 12:34:05 PM
Cognos doesnt burst/email native excel documents, it generates MHT docs. When you open the burst "excel" report in your browser, on the file menu there should be an option to open the file in excel
Title: Re: Excel output through is email not genreted
Post by: Maple on 18 Jun 2007 09:29:00 AM
hi,

Try this....

In Schedule,
> In " Report option" , tick on Delimited Text (CSV) check box
> In "Send the report by e-mail" option.... Don't forget to tick on the "Attach the report output" check box

let me know if its not working


Title: Re: Excel output through is email not genreted
Post by: MDXpressor on 18 Jun 2007 07:54:11 PM
Quote from: Maple on 18 Jun 2007 09:29:00 AM
hi,

Try this....

In Schedule,
> In " Report option" , tick on Delimited Text (CSV) check box
> In "Send the report by e-mail" option.... Don't forget to tick on the "Attach the report output" check box

let me know if its not working




If you deliver as a .csv, the file certainly will open in excel directly, but you lose all of the formatting that you may have embedded in the report.  If you want to maintain the formatting, use the method that is suggested above by Angus Miller.  You may be able to get the Excel 2000 to deliver directly to Excel rather than as an .mhtml file.  Really, just educating the user on the default behaviour is normally a satisfactory approach.

Title: Re: Excel output through is email not genreted
Post by: schafers on 01 Aug 2007 06:04:39 PM
I'm having the same issue, this time it's because my users have the Treo all in one phone.  I'm also trying to use the .pdf reader, with no luck either.  It looks like the Treo doesn't have a .pdf reader built into it.

Any other clues from others?