Ungroup repeating cells in Excel

One of the anoying things in Cognos 8.x was, when you export a report to Excel, that some grouped cells kept being grouped in Excel. So when a user wants to analyse data in Excel some data is missing (after ungrouping).

In Cognos 10 there is a property to solve this. Go to the report properties and deselect the option “Group repeating cells when exporting to Excel”

group_repeating_cells_cognos_10

 

Button types for Cognos

On a site I found various types for creating buttons on your cognos report:

PDF Button:

<input type=’Button’ value=”Report in PDF” onclick=”javascript:gCognosViewer.getRV().viewReport(‘PDF’)”>

CSV Button:

<input type=’Button’ value=”Report in CSV” onclick=”javascript:gCognosViewer.getRV().viewReport(‘CSV’)”>

XML Button:

<input type=’Button’ value=”Report in XML” onclick=”javascript:gCognosViewer.getRV().viewReport(‘XML’)”>

Excel single Sheet:

<input type=’Button’ value=”Report in Single Excel Sheet” onclick=”javascript:gCognosViewer.getRV().viewReport(‘singleXLS’)”>

Active Report button:

<input type=’Button’ value=”Report in Active Report” onclick=”javascript:gCognosViewer.getRV().viewReport(‘MHT’)”>

Excel 2007 Button:

<input type=’Button’ value=”Report in Excel2007″ onclick=”javascript:gCognosViewer.getRV().viewReport(‘spreadsheetML’)”>