Changing Columns in Matrix Report based on Group RRS feed

  • Question

  • User1610580783 posted


    I need a solution for the below problem in SSRS. I have 2 Area which 2 Points Each point is having different states. I got the group, Points and states as a table. State are the values for the row. So I have implemented the report as a matrix As I am not sure about the different states for different point.

    I need to generate the matrix report like this format by grouping the area. In turn, generating the matrix with different column name for different row. The format is below,

    AreaName A1

    Point Name       On  Off

    Analog P2          Y    Y

    Analog P1          Y    Y

    AreaName A1

    Point Name      On   Off Mode State

    Digital P1          Y     N    Y       N

    Digital P2          Y     Y    Y       Y

    Please help me the generate the as per the above format.


    Naga Sundar

    Thursday, July 14, 2011 10:36 PM


  • User1471008070 posted


    You should make use of list control, design your tablix like this:

    Column Group: Status

    Row Group: States

    Detail row: Your Data field

    Then put this tablix into the list control, then group the list by Area.

    If this is not what you need, please feel free to let us know, and also give the struture of your dataset.

    Challen Fu

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, July 20, 2011 3:58 AM