question

NishanthC23 avatar image
0 Votes"
NishanthC23 asked Joyzhao-MSFT edited

SSRS Matrix Report

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
image.png (4.9 KiB)
image.png (4.9 KiB)
image.png (2.4 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Joyzhao-MSFT avatar image
0 Votes"
Joyzhao-MSFT answered Joyzhao-MSFT edited

Hi @NishanthC23 ,
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.


01.jpg (5.8 KiB)
02.jpg (7.9 KiB)
03.jpg (7.1 KiB)
04.jpg (6.8 KiB)
06.jpg (15.9 KiB)
07.jpg (11.1 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.