Crystal report-cross tabulation Application

I originally wanted to write a summary about the application SERIES OF THE CRYSTAL REPORT, but the time was always unavailable. It seems that the Plan has been disrupted (heartache. I finished my work today. Let's take a look at some time. I wrote a cross tabulation example to illustrate the application of the cross tabulation when I solved the problem of the crystal report with a friend two days ago. I hope it will be helpful for new users. You are also welcome to switch your heads.
First, we can see the structure of this table:

Make the data in the table into a report in this format:

I came up with two methods:

First, use SQL statements in the database to reverse the rows and examples of the table. This method is pure database processing, and then you can use a common crystal report to display the data. Simple and clear, I will not sort out the specific code.

Second: Use the cross tabulation of the crystal report. This method is not feasible. You can think about it carefully and it is feasible.

The procedure is as follows:
(Dizzy, the picture cannot be sent !!)
Source code: source code