Clear Parameter Values

When you are developing a report and run it to test, value are stored from filters or the source connection. This is done so you won’t have to fill them in every time you test.

Sometimes you want to select a different source. For example first you test on DEV connection and now you want to test with QA connection.

To achieve this you want to clear the reports cached values. This can be done in Report Studio by selecting File > Clear Parameter Values

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

 

Remove Deselect at the bottom Prompt

How to remove ‘Deselect’ at the bottom of the Radio Button Prompt in Report Studio.

In a report I created a custom prompt with two values. I changed the interface to radiobutton. With some javascript the first two lines were hidden, so you only see the two selectable values. Still there is “Deselect” visible and there is no need to see that. So I want to hide it, but how? Continue reading