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

 

Group rows in cognos report list

Case:

When you create a standard table in a report you can have double rows with the same data

group_rows_1

In Cognos it is possible to group these rows

Solution:

Follow the next steps to group the rows in the table

1. Select the column in the table witch you want to group

group_rows_2

2. Choose in Report Studio –> Structure –> Group/degroup

group_rows_3

3. The result in the table after that:

group_rows_4

4. Next run the report and the result looks like:

group_rows_5