none
Merge Dynamic cells in Tablix

    Question

  • 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.

    Friday, January 24, 2014 7:02 AM

Answers

  • 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


    Alisa Tang
    TechNet Community Support

    Sunday, January 26, 2014 2:33 AM
  • Hi MaheshRapaka,

    In a Matrix, since the Data cells retrieve values based on not only the row group but also the column group, and the column group will generate multiple columns dynamically, we can't merge cells in Data Region in a Matrix.

    Alternative, I recommend you that submit a wish to the Microsoft Connect at https://connect.microsoft.com/SQLServer/Feedback. Your feedback is valuable for us to improve our products and increase the level of service provided.

    Regards,
    Alisa Tang


    Alisa Tang
    TechNet Community Support

    Wednesday, January 29, 2014 3:06 AM

All replies

  • 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


    Alisa Tang
    TechNet Community Support

    Sunday, January 26, 2014 2:33 AM
  • Hi Alisa Tang,

    Thank you for your response.

    The link was not useful for me because in that they have merged the cells at design time( Here we have predefined count of columns). But in my case, columns will be generated dynamically depeneds on the data I have.

    Monday, January 27, 2014 2:48 PM
  • Hi MaheshRapaka,

    In a Matrix, since the Data cells retrieve values based on not only the row group but also the column group, and the column group will generate multiple columns dynamically, we can't merge cells in Data Region in a Matrix.

    Alternative, I recommend you that submit a wish to the Microsoft Connect at https://connect.microsoft.com/SQLServer/Feedback. Your feedback is valuable for us to improve our products and increase the level of service provided.

    Regards,
    Alisa Tang


    Alisa Tang
    TechNet Community Support

    Wednesday, January 29, 2014 3:06 AM