on 05-04-2017 4:53 PM
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,
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.