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

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

Introduction 

This feature allows you to sort your Cross-Tab rows and columns with precision. Specifically, the 'In Specified Order' option is invaluable for organizing data that doesn’t follow standard alphabetical or numerical logic. For example, if you need to arrange a Cross-Tab by month name rather than alphabetically, here is how you can set that up.

1. Step 1: Open the Cross-Tab Expert Start by right-clicking your Cross-Tab. When the menu             appears, click "Cross-Tab Expert..." to begin customizing your layout.

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