COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: jappen68 on 07 Jan 2019 06:27:08 AM

Title: Hide column in list report
Post by: jappen68 on 07 Jan 2019 06:27:08 AM
Hi.
Have a regular report with 4 tabs and i add a column that i only want to use as a sort column.

In tab1 i have: Col1,col2,col3,col4,col5(sort column)
i cant finde any way to hide col5 from the report?
no option to hide render etc, is it any way to hide this column?

using: Analytics 11.0

BR
Jan
Title: Re: Hide column in list report
Post by: rockytopmark on 07 Jan 2019 09:50:41 AM
Select the list column you wish to hide in the report layout, and change the Visible property to: No

Become familiar with the "Select Ancestor" button, this is the key to selecting the column so the property can be changed.  Click the list columns title or detail cell then use the Select Ancestor button to select the List Column itself.
Title: Re: Hide column in list report
Post by: dougp on 07 Jan 2019 10:34:24 AM
Don't add the column to the list at all.  Use "Edit Layout Sorting.." to add it to the Detail Sort List.