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.
- Right click on the Cross Tab on Crystal Report , Click Cross Tab Expert.
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.
3. Select Common tab and Select In Specified Order from drop down.
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.
codepac 