Skip to Content
avatar image
Former Member

Sort crosstab in specific order of Months

I have created a crosstab in Crystal reports, my column data are dates to see the full Month. However I need to put the dates in a certain order rather than the correct order. I need to Show April 2016 in the first column, April 2017 in the second column, then Jan. and so on.

Is this possible to do?

Thank you in advance,

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    May 04, 2017 at 04:30 PM

    Hi Matt,

    In the Cross-Tab expert, add your date to the columns box and press the Group Options button. In the Commons tab you can set the order. There is an option for In Specified Order. You can create groups and put them in which ever order you want. I'd recommend creating a group for April, 2017 April, 2016 and the an Other group for the rest of the months.

    Good luck,

    Brian

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Good idea, however I am going to have to create a formula to change my first 2 columns to look back 30 days from the time the report is ran. But this is a great starting point and gets me in the proper direction.

      Thank you,