Among the various controls provided by SSRs, the most important controls are those associated with datasets for displaying data, such as tables, matrices, and graphics, the controls that can be associated with a dataset are called dataregion ). Data areas can be nested. The most common is embedding charts, data entries, and spark charts in a matrix. To understand how nested data areas display data, we must first understand the Visible data range in the nested data area design. We use a matrix as an example.
Assume that the dataset has the following structure, which has four columns, three dimension columns and one measurement value column:
Date
|
Department |
Product |
Sales Volume |
After we drag the Matrix to the interface for the first time, the matrix has a total of four areas:
Area 1 is the upper left corner of the matrix. The data in this position is the same as that in the entire matrix, that is, the data in the entire four columns can be accessed from this. Therefore, if we drag a graphic control, such as a pie chart, to aggregate and display the entire data associated with the matrix, such as placing the Department on the category, place the sales volume on the value to display the sales volume information of each department.
Area 2 is a column group, which can access data in the column group. We generally do not nest other data areas here, because it is generally used only to show all data in the column group as the column label
Area 3 is a row group, which can access all data in the row group. We generally do not nest other data areas here, but simply display the row group data as a label.
Area 4 is a data column that can access the dataset after the row group column and column group column of the group. If a chart is dragged here, the data of each chart has been screened by specific members of the row group and column group.
650) This. width = 650; "src =" http://s3.51cto.com/wyfs02/M00/4C/54/wKioL1Q7j7myTcPjAABOmWrsbE8881.jpg "Title =" 1.png" alt = "wkiol1q7j7mytcpjaabomwrsbe8881.jpg"/>
Then we can create a new column after the column group, such as all, so there are two more cells, 5 of which has the same data range as 1, the data range of Column 6 is the data after the row group. That is to say, if we put the Department on the row group, the data set that can be accessed in cell 6 is equivalent to getting all other columns (date, product, sales volume) of the specific department from the source data set. 6 is usually used to place data entries or spark graphs. For example, we can place a spark graph. The sparkline uses the sales volume as the value and the date as the category, then we can show the sales trends of specific departments over time:
650) This. width = 650; "src =" http://s3.51cto.com/wyfs02/M02/4C/53/wKiom1Q7j3jSBP0iAABcudtPNBc271.jpg "Title =" 2.png" alt = "wkiom1q7j3jsbp0iaabcudtpnbc271.jpg"/>
In addition to the column group, you can create another column in the column group, as shown in. In this case, the data range of 1, 2, 3, and 4 remains unchanged, and the data range of 5 is the same as that of 4:
650) This. width = 650; "src =" http://s3.51cto.com/wyfs02/M02/4C/53/wKiom1Q7j2_AmsZBAABflatpmh8581.jpg "Title =" 3.png" alt = "wkiom1q7j2_amszbaabflatpmh8581.jpg"/>
SSRs-nested data area