Skip to Content
0

Sort crosstab in specific order of Months

May 04, 2017 at 03:53 PM

38

avatar image

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,

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Brian Dong May 04, 2017 at 04:30 PM
0

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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,

0