VS2010 RDLC Report matrix detailed grouping, totals, table header, display direction, serial number

Write a little of your own experience to make Mark

~~~~~~~~~~~~~~~~~~

After you set up row and column groups, the General column group is dynamically rendered based on the category of the row group, sorted by column groups, sorted by set in the DataSet, and in the following chart operation order

can add

~~~~~~~~~~~~~~~~~~

1. The data in the report can not be exported when the form of the neutron report is exported into Execl file

If you can export with a list but the data is not merged

2. The matrix adjustment group must adjust the group of matrices instead of adjusting the properties of each text box

3. All of the data in the following group (in a column that is in a group) is the smallest unit of the group.

If you want to not merge duplicates, the group expression in the matrix should be =first (fields! Description.value)

If you want to merge the expression should be =fields! Description.value

4. Totals for each group in the report

Select the group you want to aggregate right-click Subtotal

5. Text direction in cell

Cell PROPERTIES---format---mode

WRITINGMODE:TB-RL Portrait (vertical)

WRITINGMODE:LR-TB level

6. Matrix Grouping by what group

is not determined by the cell before and after, but by editing the attributes grouped in the group

The grouping here is not the same property as the one shown

Display of 7.RDLC serial number

7.1 Non-grouped =rownumber (Nothing) expressions

7.2 Group Display

=rownumber ("Matrix1_mediumname") Matrix1_mediumname is the group name

Here you can write the name of any group

According to that group, write the group name.

8. About Group Folding

Group Properties:

8.1 One is the Select matrix right key property---group---edit

8.2 Select Group text box right--edit group this and 8.1 is a meaning

8.3 Select Group text box right--Properties--visibility

9. The processing of matrix grouped table head

Table headers cannot be nested after grouping because nested tables, when the report is exported to Excel, the header complains: ignores the data area within the table/matrix cell.

You cannot use a list control, and if you use a list control to display multiple rows of headers, you can use only rectangular controls.

10. Add a row after the matrix total

Put the row inside the rectangular control to prevent dislocation, each text box width must be and above always, otherwise will be dislocation (there may be no dislocation of the report but export Excel dislocation), and then the contents of the text box passed through the parameters to this page.

11. Text box Border Repeat, even if you have set the left border to none but still have, so here to set the overall border of none, and then put the need to add a border position to solid, we note that here the default value of None.

12. Remove the folding symbol in front of the matrix grouping

Removes the Department, Project field properties---Visibility---can be determined by other associated report items.

Select a matrix group to navigate to the property modification once

Then select the cell property and then modify it again