Sorting a Crystal Reports Cross-Tab: A Step-by-Step Guide

In Specified Order (Crystal Report Cross tab)

Learn how to precisely control the order of your Cross-Tab groups with the "In Specified Order" sorting option.

Introduction 

Using this option, you can sort your Cross-Tab's rows and columns. Specifically, the "In Specified Order" option is helpful for sorting data that cannot be sorted in the regular alphabetical or numerical way.

For a real-world example, let's consider a scenario where we want to sort a Cross-Tab by month name. Here's how to do it.

1. To begin, right-click on the Cross-Tab in your report. From the menu that appears, click                  "Cross-Tab Expert..."

Select Cross-Tab Exprert

2. Below the column and row sections, you will find the "Group Options" button. Select the              column or row field that you need to sort in a specific order, and then click this button.

Group Option

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

In specified order.

4.  Next, select the "Specified Order" tab and click the "New" button to add an item to your custom sort order.

You will then enter the Group Name and select a condition, followed by its corresponding value. For our scenario, you would enter January as the Group Name, select the "is equal to" condition, and enter January as the value.

You will need to repeat this process for all the months of the year to create your desired sort order.

User define order