Complex statistics using the rdlc matrix (composite table header)

Complex statistics using the rdlc matrix (composite table header)

PreviousProgramRdlc reports are only the simplest part. You can draw a table, PASS Parameters, and assign data sources.
A while ago, I went to install the software for the customer, and required a data analysis, data, and format.
It should be summarized according to different categories, with layers and totals.

I started to use reports and conducted experiments. It was found that it was difficult to implement multi-level grouping and grouping by combination. If a subreport is nested, when exporting an Excel file, the child table data is not displayed.
I saw a matrix on the report control, so I checked it online and got a rough idea... so I started to do it.
Work:
1. Define the columns used to design the data source.
2. Create report Parameters
3. Place the matrix in the workspace and set the relevant attributes of the table (such as border and color)
4. Place the grouping data source to the "column" position displayed in the Matrix. If there are more than one data source, right-click the existing group, select "insert group", and add the data source again.
5. Place the row grouping data source to the position where the "row" is displayed in the Matrix. If there are more than one data source, you can add it again like a column group.
5. place data columns on the Data Partition. For example, you can right-click a new group and select "add column ", this will automatically generate a "new line" in the column access to display the corresponding data source column name, you can edit the displayed column name/comment
6. total, right-click the group and select "subtotal. note that if "subtotal" is added and the column name can be changed, the "sum () function" must be added to the data column. Otherwise, only the first data item is displayed for the total column.
Effect

The title and query conditions passed in with parameters.
The following table has two column groups, one row group, two data columns, and one column subtotal (the row subtotal is generated in the data source using code)
 

Source post: http://www.cnblogs.com/Gerry-BJ/archive/2008/09/25/1195450.html