If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Excel output through is email not genreted

Started by koolbachi, 12 Jun 2007 09:41:13 AM

Previous topic - Next topic

koolbachi

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


goose

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

Maple

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



MDXpressor

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.

No, a proof is a proof. What kind of a proof? It's a proof. A proof is a proof, and when you have a good proof, it's because it's proven.

-Jean Chretien

schafers

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?