Cognos 8.3 - " Download to excel"

[mimariposa]

Hi,

I am trying to simulate a Navigation menu with the aid of a Cognos 8.3 Report studio report that has:

1. A vertical dropdown menu,with links to other reports (as menu items)
An Iframe

2. Each of the menu items(report links) when clicked,open the corresponding report in the Iframe.

I would like to create a "Download-to-excel" button above the navigation menu,which when clicked opens/saves the current IFrame report in a new window in excel/pdf formats..Any help in this regard is appreciated.

Thanks in advance.

[Suraj]

JavaScript and possibly SDK comes to mind.

[mimariposa]

Thanks Suraj.I figured it out.Didn't require SDK!!!
I had to add an html element in the report and include the following code:

For Cognos 8.3 only:
<a href="#" onclick="oCV_NS_.getRV().viewReport('XLS');"><img src="/_images/xxx.gif" alt="Export to Excel"></a>

For CRN/Cognos 8/8.2:
<a href="#" onclick="return runInFormat('XLS');"><img src="/_images/xxx.gif" alt="Export to Excel"></a>

Note:'XLS' is an argument and can be replaced with 'PDF','CSV' etc.

[Suraj]

Thanks for sharing... but the code just adds a button to export to excel which is already available on the top bar by default.

Did you get any solution of the drop down menu for other reports?

[mimariposa]

Yes.
I had to add a javascript function (runFormat(format)) and call it on the button click event. Hope this helps.

<script>
function runFormat(format) {
   if(typeof(top.frames['IframeID'].document.forms[0]) == 'object')
   {
      var f = top.frames['IframeID'].document.forms[0];
      top.frames['theiframe']['oCV'+f['cv.id'].value].getRV().viewReport(format);
   }
   else
   {
      alert('select a report first.');
   }
}
</script>

[EArumugam]

i paste the code in html. report open in excel but the fillter condition not working properly

[joroise]

If I want to change the name of excel file. How can I do then?