Month sorting on Crosstab

[barrysaab]

Hi gurus, I have Product Id on rows and month as columns in Crosstab,but the month is not appearing in proper order for example Jan,Feb----Dec.I remember doing the same for list report a while ago by taking a new data item and writing a case statement of If month='Janauary then (1) .Do I need to do same thing for crosstab too.Appreciate your help.Thanks

[blom0344]

Yes, do the same for the crosstab. You can associate this data-item with the crosstab , by adding it to the properties of the crosstab header if you do not want it in the layout..