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

 

Cognos Error RSV-VAL-0032

This article explain how I got Cognos Error RSV-VAL-0032 and solved it.
In a report I have a filter on Date From. It works with a DatePicker Prompt. Often the client wants to print the report or view in PDF. When the report is started and no Date From is chosen, the parameter p_date_from is empty. So when I show this parameter in the report it is empty.
To solve that I created a report expression with the following case:

Continue reading