Click here to Skip to main content
13,597,584 members
Click here to Skip to main content
Add your own
alternative version

Tagged as


6 bookmarked
Posted 14 Nov 2012
Licenced CPOL

Custom sorting for Crystal Report Cross-Tab

, 14 Nov 2012
Rate this:
Please Sign up or sign in to vote.
Article describes how to apply a custom sorting for Cross-Tab


Following article guides you to apply a custom sorting functionality to a Crystal Report Cross-Tab. Hope you have some basic knowledge in creating a basic crystal report.


Following illustration shows before applying the sorting functionality. Below image shows wrong order of month on column headers. Let's try to order the column headers on as Jan, Feb, Mar...etc. 


Open the Crystal Report on the designer and select Group Options on Column section on Cross-Tab expert. 

On the the Common tab select "In Specific Order" from sort drop down. On the specific Order tab select New button. 

Now add each group for each moth. Type the group name as "Jan" and "is equal to "Jan". The value you enter here should be match with data on Month column on your data source. Once all months are added output will display as follows 

Now if you want change column order Up/Down arrow can be used. Let's say financial year start with April, you can set the month on top using arrows. 

Points of Interest 

  • Typed DataSet is used to create the report schema.
  • 3 column (Month, Qty, Product) data table with dummy data is used populate the report
  • Cross-Tab is added to the report from the designer 


  • Nov 14, 2012: Article created. 


This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


About the Author

Chamila Nishantha
Software Developer
Sri Lanka Sri Lanka
No Biography provided

You may also be interested in...

Comments and Discussions

QuestionDate wise Employee attendance Crystal reports in using C# Pin
chitresh suman31-May-15 22:39
memberchitresh suman31-May-15 22:39 
Questioni Need add Record Number in Column Crosstab Pin
opasid16-May-15 7:31
memberopasid16-May-15 7:31 
Questioncrystal report Pin
Member 112886605-Dec-14 1:26
memberMember 112886605-Dec-14 1:26 
Questionplease do it with coding Pin
karimkpg28-Apr-13 3:20
memberkarimkpg28-Apr-13 3:20 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

Permalink | Advertise | Privacy | Cookies | Terms of Use | Mobile
Web02 | 2.8.180621.3 | Last Updated 14 Nov 2012
Article Copyright 2012 by Chamila Nishantha
Everything else Copyright © CodeProject, 1999-2018
Layout: fixed | fluid