Product.Category ID = Category.Category ID) as Right-click on the newly created NWind_CHS data source and select the Add Data Set menu item. Open the report explorer and create the report data source according to the following information name: After the creation is complete, select Convert to Continuous Page Layout (CPL) report from the report menu item of VS to convert the fixed page report Convert to continuous page report. The project template used is the ActiveReports page report. 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, so as to realize the data drill-down function. At runtime, when combining report data and data areas, as you add columns to column groups and rows to row groups, the matrix will grow horizontally and vertically on the page. 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 group 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. While setting up the column, we can also set the grouping information of the report to complete the grouping display and data statistics of the data.In ActiveReports, you can easily implement cross-reporting through the matrix control. Run the report to get the following results: Switch to the report design interface, select the detail area, and set the following properties in the properties window: ColumnCount
Run the report to get the results shown in the figure below: Select the report detail area and set the following properties in the properties dialog: ColumnCountĭrag and drop data fields from the Report Explorer to the report design interface to get the following design structure:ġ.3. After the report is created, click the data source chart in the upper left corner of detail and create the report data source according to the information in the following figure:ġ.2. The selected project template type is ActiveReports 7 area report (based on code). Add an ActiveReports report file named rptAcrossDown.cs to the ASP.NET application.
This article mainly explains how to implement horizontal column, vertical column and group column report in ActiveReports.
The column reports commonly found in the business report system include product labels, employee cards, and bar code printing. You can set the horizontal column and vertical column, and set the column and group at the same time, and count the subtotals and totals of the column grouping. In ActiveReports, you can implement the layout style of the column report.