Hi,

My Data looks like below.

ColNo    Pod    RowNum
1           1       1
2           2       1
3           3       1
1           4       2
2           5       2
3           7       2
1           8       3
2          9        3

In the Report I used tablix to display the data by using RowNum as RowGroup and COlNo as ColGroup. I used page break to show each row in a seperate page. Then I am getting the output like below in differene pages.

 Pod Pod Pod

   1   2    3

   4   5    6

   8   9

 and My question is I need to add one extra row which I need to display in every page and all the columns in that row has to be merged. In this tablix, all the columns are dynamically generated, So I donno how to merge it.

Can anyone provide me the solution for this.

Hi MaheshRapaka,

If I understand correctly, you want to add an extra row in the end of the matrix, and you want merge all columns in the row.

In SSRS, we can merge cells in a data region to combine cells, improve data region appearance, or provide spanning labels for column groups and row groups. However, cells can only be merged within each area of a data region. We cannot merge a cell in the data region corner area with a cell in the row group area.

There is an article about Merge Cells in a Data Region, you can refer to it.
http://technet.microsoft.com/en-us/library/bb630416(v=sql.100).aspx

Regards,
Alisa Tang