COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Active Reports => Topic started by: roey on 17 Dec 2013 06:43:30 AM

Title: Active Report & Excel question
Post by: roey on 17 Dec 2013 06:43:30 AM
Hi All,

I wanted to know if there is way to export/send by email the Active report as Excel.

Regards,
Roy.
Title: Re: Active Report & Excel question
Post by: BigChris on 17 Dec 2013 08:03:50 AM
As far as I know it has to be in .mht format. Excel won't have the interactivity that comes with Active Reports.
Title: Re: Active Report & Excel question
Post by: MFGF on 17 Dec 2013 09:37:51 AM
Quote from: roey on 17 Dec 2013 06:43:30 AM
Hi All,

I wanted to know if there is way to export/send by email the Active report as Excel.

Regards,
Roy.

Quote from: BigChris on 17 Dec 2013 08:03:50 AM
As far as I know it has to be in .mht format. Excel won't have the interactivity that comes with Active Reports.

Exactly as Chris says. Active Reports are rendered as MHT to allow the interactivity. There is no option to render them in Excel. If you want to send a report in an Excel format it will need to be a non-active report.

Cheers!

MF.
Title: Re: Active Report & Excel question
Post by: Chandrasekar on 16 Jun 2014 05:08:50 AM
1.Create one html item
2.Copy this script
<input type='Button' value="Report in Excel 2007"  onclick="javascript:gCognosViewer.getRV().viewReport('spreadsheetML')">
3.Excute

Thanks & Regards,
Chandrasekar