Create a report fileĬreate an ActiveReports report file named rptCrossTable1.rdlx in the application. The following are the detailed implementation steps: 1. Column grouping is grouped by product category and product name row grouping is grouped by year and month, and data with sales greater than 2000 is highlighted. What we are going to demonstrate here is the product sales data analysis table. In the matrix control, you can also include a detail switch that initially hides the detailed information data, and then the user can click the switch to display more or less detailed information as needed, thereby realizing the data drill-down function. At runtime, when combining report data and data areas, the matrix will grow horizontally and vertically on the page as columns are added to column groups and rows are added to row groups. At the same time, you can group data by multiple fields or expressions in row groups and column groups. The number of rows and columns of the group in the matrix control is determined by the number of unique values in each row and column group.
At the same time, you can also set data grouping, sorting, filtering, subtotal, totaling and other operations, which can meet the needs of intelligent data analysis for your reports. In ActiveReports, you can easily implement cross-reporting through the matrix control.