COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: pammassey on 06 Sep 2017 08:55:01 AM

Title: Crosstab Sorting Issues
Post by: pammassey on 06 Sep 2017 08:55:01 AM
I have created a crosstab report where the column headers are months spanning a year sorted descending.  The quantity that appears beneath those columns are the correct quantities but they're not aligning under the correct months.  Any ideas on how to address this issue?
Title: Re: Crosstab Sorting Issues
Post by: pammassey on 06 Sep 2017 09:35:10 AM
The crosstab spaces I used to create column headers for the crosstab is creating the issue.  When they're not there, the numbers appear under the right months.
Title: Re: Crosstab Sorting Issues
Post by: New_Guy on 07 Sep 2017 08:49:24 AM
Hi,
Column headers can be created using tables and blocks in the crosstab nodes itself by unlocking the nodes. Check the pad lock icon on the tool bar. If you have to use the crosstab spaces then you have to do the boxtype none to the actual month nodes and the crosstab space fact cells has to be boxtype none too.
Good luck
New guy