Create a Matrix Report

A matrix (cross-product) report is a cross-tabulation of four groups of data: One group of data is displayed across the page. One group of data is displayed down the page. One group of data is the cross-product, which determines all possible locations where the across and down data relate and places a cell in those locations. One group of data is displayed as the "filler" of the cells.

矩阵报表是由四个组组成交叉报表，一个组是以横向方式显示（列头），一个组是以纵向方式显示（行头），一个组是由横向和纵向的组交叉组成的，用来确定和横向与纵向相关联的数据的位置，并在这些位置上产生单元格。另一个组是用亚向这些单元格里填数据的。

最终效果如图：

Data Mode如图：

两个重要属性的解释（俺英文不好，不做翻译，怕误人子弟，所以只要俺能看懂就行了）：

Product Order property
The Product Order property specifies the order in which groups are evaluated in the cross product for a summary. Product Order also defines the frequency of a summary, formula, or placeholder in a matrix (cross-product) group. That is, the summary, formula, or placeholder has one value for each combination of values of the groups in its Product Order. Product Order is used only for columns owned by cross-product groups. Because a cross product relates multiple groups, the groups in the cross product could be evaluated in any one of many different orders. Therefore, when creating a summary for a cross product, you must use Product Order to specify for Reports Builder which group should be evaluated first, which second, and so on. You must also use Product Order to specify the frequency of a summary, formula, or placeholder within the cross product.

Product Order指出要对cross product的哪个group求summary(SUM,AVG,MAX,MIN etc.)的值。

Reset At property
The Reset At property specifies the group at which the summary column value resets to zero (if Function is Count), null (if Function is not Count), or Value If Null (if the column has one). Reset At has a list of values containing valid reset groups. Reset At determines if the summary is a running summary or a periodic (e.g., group-level) summary.

Reset At 属性指出summary的值是当哪个group的值变化时，重置为0。

制程过程演示：

http://files.myopera.com/xlingFairy/swf/matrixReport.swf

4.4M，如果想看，请耐心等待。