Cross tabulation and cross tabulation data sorting settings

 Cross tabulation and cross tabulation data sorting settings

[Source] http://blog.chinaunix.net/u/22472/showart.php? Id = 153675

This article describes how to create a cross table and how to customize it.

Crystal Report 9.2, also applicable to Crystal Report 10 (inclusive) and earlier versions

Preparation

First, you need to know what a cross tabulation is, and under what circumstances do you need to use a cross tabulation?
A cross tabulation object is a grid that returns values based on specified conditions.
Data is displayed in compressed rows and columns. This format is easy to compare data and identify its trend. It consists of three elements:
Line
Column
Summary Field

I have made a simple table to describe it. I believe you can quickly match it with your application.

Okay. Now let's start.

Step 1: Create a crosstab chart from scratch


Here I simply select a table. The data in this table is not suitable for cross tabulation.
However, I only use it for demonstration purposes.

Select the data you want to display on rows and columns and the corresponding summary.

Do not select charts here.
Okay, cross tabulation is complete.

Step 2: Set the data display sequence of the row and column

Sometimes, we find that the order of data display is not what we want, so we can set it by ourselves.
Go to the cross tabulation expert
Select the fields to be reordered, and click "group options"
A small window appears. There are three types of sequence: ascending, descending, and specified.

There is no "Original Order" here, so the order is often messy.
At this time, we will select "specify order" and re-specify it. We need to note that if there is too much data, it will be very difficult, but there is no way.
At this time, two tabs are added to the interface.

The crystal report automatically lists the sensor data. You can select one of them to list them in the following list.

If you are using field definitions and other methods that do not directly connect to the database, there will be no data here
You need to specify it by yourself. Click "new" to perform the operation.
You can also set only a few data points that you are concerned about. If so, you need to pay attention to the following "other" tab
There are three options
The first one is: all others are discarded.
The second one is: Put the other together.
The third is: keep them in their respective groups. Data without the set sequence is arranged in the original display order behind the data you set
We generally select the third

Okay. Now the data is out. Is the result displayed? You can also set the display sequence of row data.

There are also some other settings for the cross tabulation. You can go to the cross tabulation expert and make some settings in "Custom styles ".
Such as suppressing the display of empty rows or columns

There is a gap in the upper left corner of the crosstab chart. This should be a sign of the crosstab chart, but it is not in line with Chinese report habits.
If it's just one page, you can also draw a line by yourself or block up an image,
However, this gap is displayed on the following pages during cross-page display.