SSRS Matrix Report

Nishanth 1 Reputation point
2021-10-05T12:28:11.287+00:00

I want to show the grouped column values in parallel.

This is the sample data I have, All the values under same Block. I created one Matrix report and Row as Block and Column as Flat, when I run report it's only showing the First value of each column.

When I insert the Building No. in Row group it's printing like the below 2nd Image,. But I want to show my report like the 3rd picture.

Under Group "Block 1"--> Each Flat Columns--> Print Corresponding Building Number

137764-image.png

137791-image.png

137755-image.png

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,862 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Joyzhao-MSFT 15,571 Reputation points
    2021-10-06T02:33:02.967+00:00

    Hi @Nishanth ,
    Before that, we need to understand the properties of the Matrix. Matrices provide functionality similar to crosstabs and pivot tables. The number of rows and columns for groups is determined by the number of unique values for each row and column groups.
    The following figure shows the initial matrix template, selected on the design surface:
    137935-01.jpg
    When you drag the fields into the matrix separately, the [Data] displays the sum of the row group and column group crossed, as shown in the figure below:
    137952-02.jpg
    137953-03.jpg
    If you manually change the expression of [Data] to "=Fields!BuildingNO_.Value", you will only get the value of the only row.
    137937-04.jpg
    As you have done so far, you may add the Building No. field in the row group, as shown in your Figure 2. In your figure, "123", "456", and "789" are displayed in a row, and "987" , "654" is displayed in the second row. What is the basis for this division? What I mean is that there are two values for Type FlatA and FlatB, why not "987", "456", "789" is a row or 987", "654", "789" is a row? As shown in the figure below :
    137973-06.jpg

    Therefore, the graph we can finally obtain through Matrix will be as shown in your figure two:
    137924-07.jpg
    I think we cannot determine which row its value appears in for a Type field with two or more values.
    Best Regards,
    Joy


    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments