COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: gosoccer on 05 May 2017 11:10:28 AM

Title: CUT a Column in Report Author to Hide (Relational)
Post by: gosoccer on 05 May 2017 11:10:28 AM
I used to know this but does cutting a column (not deleting) gets rid of the logic that is related to that column
associated to a crosstab Report? Or Cut just takes it off the Layout of the Report but the logic still exists.

Thanks a lot :o :o
Title: Re: CUT a Column in Report Author to Hide (Relational)
Post by: Ravisha on 05 May 2017 11:15:54 AM
It takes out the column from the list but the logic is still intact in the query associated with the crosstab. But the trick to making the logic work is to assign the data item (which contains the logic) to the "property" (option in the properties pane) list of the crosstab.

Hope that helps.
Title: Re: CUT a Column in Report Author to Hide (Relational)
Post by: gosoccer on 05 May 2017 11:22:18 AM
AHH. That's what I forgot. Thanks so much. I appreciate your time.
Title: Re: CUT a Column in Report Author to Hide (Relational)
Post by: Ravisha on 05 May 2017 11:32:10 AM
no problem.

To be more precise, please be advised that when you select the whole crosstab you won't find the property option 'Properties' (under DATA). You've to select a specific crosstab node (either columns or rows) and then the option appear in your properties pane.

Thanks
Title: Re: CUT a Column in Report Author to Hide (Relational)
Post by: gosoccer on 05 May 2017 11:37:07 AM
Yes, you are 100% correct. I'm glad I knew this one. Thanks a lot :) :)