COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: palanivelu on 17 Jun 2010 04:28:34 AM

Title: Changing the column order while running the report in crosstab
Post by: palanivelu on 17 Jun 2010 04:28:34 AM
Hi All,
       
Iam currently running a crosstab report for which a single column that is inserted in to a report is giving 10 columns while running the report. I would like to change the order of the columns and would someone be able to give me a solution for how to change the order of the column while running a report as i want for example 5th column to the 1st column in the cross tab.

Thanks,
Palanivelu
Title: Re: Changing the column order while running the report in crosstab
Post by: MFGF on 17 Jun 2010 04:42:39 AM
Have you tried defining a sort on the column headings?  I assume that the item you used for columns has 10 distinct values - these can be sorted just like any other data.

Regards,

MF.