Grouping coloumnwise in RDLC report? RRS feed

  • Question

  • Hi,

    How can i perform columnwise grouping in RDLC report.

    The data from the database is as follows

    The report header is as follows

    Friday, January 10, 2014 9:22 AM


  • Hi kSgKrissh,

    If I understand correctly, UATRelease and ProductionRelease is the Environment column’s values.

    In SQL Server Reporting Services (SSRS), if we are use matrix to display data and summary information, we can group data by multiple fields or expressions in row and column groups.
    Reference: http://technet.microsoft.com/en-us/library/dd207149.aspx

    Suppose we have a dataset with above fields. Please refer to the following steps:

    1. Add a matrix in the report body.
    2. Add Environment field in the Columns text box.
    3. Right click the column select Insert Column -> Insert Group-Right. Add two insert column in the matrix.
    4. Then, add currRelease, PreRelease, appDate fields in the text box below Environment Group.
    5. After that, we can according to our requirement to add other fields in the matrix and adjust the matrix.

    If there are any misunderstanding, please feel free to let me know.

    Alisa Tang

    Alisa Tang
    TechNet Community Support

    • Proposed as answer by Alisa Tang Thursday, January 16, 2014 1:57 AM
    • Marked as answer by Alisa Tang Monday, January 20, 2014 2:27 AM
    Sunday, January 12, 2014 8:36 AM