In ActiveReports, You can implement the layout style of a column-based report. You can set horizontal and vertical column-based reports. You can also set column-based and group-based tabs to calculate the subtotal and total of column-based groups. In the business report system, product tags, employee badges, and bar code printing are commonly used in column-based reports. This article describes how to implement horizontal column sharding, vertical column sharding, and grouped column sharding reports in ActiveReports.
1. Horizontal Column report
1.1 add an ActiveReports report file named rpt1_ssdown. cs to the ASP. NET application. The selected project template type is ActiveReports 7 regional report (based on code ). After the report is created, click the data source chart in the upper left corner of detail to create the report data source according to the information in the following figure:
650) this. width = 650; "width =" 643 "height =" 485 "title =" ActiveReports report function display report data source "style =" border-width: 0px; display: inline; "alt =" ActiveReports report function display report data source "src =" http://www.bkjia.com/uploads/allimg/131228/204G26422-0.png "border =" 0 "/>
1.2 select the Report detail area and set the following properties in the Properties dialog box:
ColumnCount |
2 |
ColumnDirection |
AcrossDown |
Drag the data field from the report Resource Manager to the report design interface, and finally obtain the following design structure:
650) this. width = 650; "width =" 644 "height =" 201 "title =" ActiveReports report function displays horizontal column-based reports "style =" border-width: 0px; display: inline; "alt =" ActiveReports report function show horizontal bar Report "src =" http://www.bkjia.com/uploads/allimg/131228/204G242E-1.png "border =" 0 "/>
1.3 run the report and get the following results:
650) this. width = 650; "width =" 644 "height =" 354 "title =" ActiveReports report function displays horizontal column-based reports "style =" border-width: 0px; display: inline; "alt =" ActiveReports report function show horizontal bar Report "src =" http://www.bkjia.com/uploads/allimg/131228/204G25C3-2.png "border =" 0 "/>
2. Vertical Column report
Switch to the report design page, select the detail area, and set the following properties in the Properties window:
ColumnCount |
2 |
ColumnDirection |
Downloadss |
Run the report to obtain the following results:
650) this. width = 650; "width =" 643 "height =" 354 "title =" ActiveReports report function displays vertical column-based reports "style =" border-width: 0px; display: inline; "alt =" ActiveReports report function display vertical bar Report "src =" http://www.bkjia.com/uploads/allimg/131228/204G22129-3.png "border =" 0 "/>
3. Grouping and column report
You can also set the group information of a report to display data in groups and perform data statistics. We add the Data grouping function based on the vertical column, select detail, right-click and select insert-> group Header/group end, and set the following attributes of groupHeader1:
ColumnGroupKeepTogether |
True |
DataField |
Category name |
GroupKeepTogether |
FirstDetail |
KeepTogether |
True |
RepeatStyle |
OnColumn |
650) this. width = 650; "width =" 644 "height =" 269 "title =" ActiveReports report function show grouping and column Report "style =" border-width: 0px; display: inline; "alt =" ActiveReports report function display group column Report "src =" http://www.bkjia.com/uploads/allimg/131228/204G252R-4.png "border =" 0 "/>
The running result is as follows:
650) this. width = 650; "width =" 644 "height =" 521 "title =" ActiveReports report function show grouping and column Report "style =" border-width: 0px; display: inline; "alt =" ActiveReports report function display group column Report "src =" http://www.bkjia.com/uploads/allimg/131228/204G24625-5.png "border =" 0 "/>
Online Demo and source code:
Http://www.gcpowertools.com.cn/products/activereports_demo.htm
650) this. width = 650; "src =" http://www.bkjia.com/uploads/allimg/131228/204G261F-6.png "/>
This article from the "grape city control blog" blog, please be sure to keep this source http://powertoolsteam.blog.51cto.com/2369428/1255834