Classic Crystal Report Design - Realize the transcript with cross reports!
Demand: I have a data sheet now. It is the name, student number, course name, grade. Now I hope to do a report, the fields in the report are student numbers, and each class. That is, if I have two lessons, they are both language and mathematics, and the fields in my report should be the student number, language lessons and mathematics results. ------------- ----------------------------------- Solution: Cross-report ...
----------------------- | Columns: Course Name || ----------------- | -------------------- || Line: Student Versers Field | Summary Field: || | Maximum (Redissible Field) || --------- ------------------------------
------------------------------------------------reference: 1, what is a crosstab? The "Cross-Table" object is a grid that returns a value according to the specified condition. Data is displayed in the compressed row and columns. This format is easy to compare data and identify its trend. It consists of three elements:
Row column summary field
The rows in the "Cross Table" extends in the horizontal direction (from one side to the other). In the example above, "Gloves" is a row. The columns in the "Cross-Table" extends in the vertical direction (up and down). In the example above, "USA" is a column. The summary field is located at the intersection of rows and columns. The value of each intersection represents a summary (summary, counting, etc.) that meets the records of the row conditions and the column conditions. In the example above, the value of "gloves" and "US" cross is four, which is the number of gloves sold in the United States. "Cross-Table" can also include several total:
The end of each row is the total of this line. In the above example, the total represents a product in all countries in all countries. The value of the "glove" line is 8, which is the total number of gloves sales in all countries / regions. Note: The total column can appear at each line.
The bottom of each column is the total of the column. In the above example, the total represents all products in a country. The value of the bottom of "The United States" is four, which is the total number of all products (gloves, belts and shoes) in the US. Note: The total column can appear at the top of each row.
The intersection of the "Total" column (Total "and" Total "(Total) Line (Total Total) is a total. In the above example, the value of the "total" column and "total" running crossing is 12, which is the total number of sold in all countries in all countries.
