Crystal Report Cross Tab Sorting

In Specified Order (Crystal Report Cross tab)

In this tip , you will learn cross tab Group sorting option called "In Specified Order"

Introduction 

Using this option you can sort cross tab grouping rows and column. Specially ,In Specified Order option help you to sort detail that can't sort regular way. Let's take one of real world scenario like this, when we want to create cross tab sorting month name wise. Let's see how to do it.


1. Right click on the Cross Tab on Crystal Report , Click Cross Tab Expert.

Select Cross-Tab Exprert

2. There are buttons (Group Option) bellow column and row of cross tab , Select Column or Row            field need to add Special order   and click Group Option Button.

Group Option

3.  Select Common tab and Select In Specified Order from drop down.

In specified order.

4.  Then select Specified Order tab and click new button to add order. Then enter Group Name and  select the condition and enter value in front of it. Here I entered January as group name and  select "is equal to " condition and January as a value , Likewise you need to add all months in year according to your scenario.

User define order