Matrix Help needed

Question

Post reply

Matrix Help needed

Newbi

SSCertifiable

Points: 6546
More actions
November 28, 2016 at 8:11 pm

#319344

I have to display Subtotals for each category using Matrix table just like this without modifying anything in Custom Code and or in Dataset.
Currently I am getting overall total instead of subtotals.
Another thing is that I want to limit the number of columns for the matrix just like in the photo.
What I have tried:
For total: I tried to add a adjacent row and have my total in that cell, it is giving me like:
In my designer :
Where am I missing?

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

pietlinden SSC Guru Points: 63503 More actions · Answer 1

Some sample data to play with would help a LOT.

One way of doing it is this:

SELECT 100 As Amount, 'AB' AS CustomerID

UNION ALL

SELECT 200 , 'CD'

UNION ALL

SELECT 300, 'BB'

then folks here can just copy & paste it into SSRS and it will run. Then since we have the same data as you, our matrixes should match... makes everyone's life a lot easier...

Thanks!

Newbi SSCertifiable Points: 6546 More actions · Answer 2

Thank you. But how can I do without touching my dataset?

Newbi SSCertifiable Points: 6546 More actions · Answer 3

My Table details are a little different what the above post.

CREATE TABLE [dbo].[Details](

[CategoryID] [nvarchar](20) NULL,

[Quantity] [int] NULL,

[Vol] [decimal](6, 3) NULL

) ON [PRIMARY]

GO

Where I am using Vol as subtotals( instead of Quantity)

Thank you.

This is what I am getting now( I want to appear CatID and MGZ,NWP,VCA in only one row)

Newbi SSCertifiable Points: 6546 More actions · Answer 4

I am getting it finally.

I have to remove Group in Row, after that it display nicely for displaying subtotals.

But, I couldn't able to limit the number of columns. Any Idea on this????

Newbi SSCertifiable Points: 6546 More actions · Answer 5

But, I couldn't limit the number of columns yet.

Row number limiting is not working in matrix, moreover ?

I want to have total 7 columns (including the header column). If it exceeds then it will continue just underneath it.

Any idea on this?

Jamie Ingram-729524 SSCommitted Points: 1573 More actions · Answer 6

Hi,

Pre format your data in a table.

Use the table as the data source for a tablix report.

Eg

--4 Col table

Group1 Col1

Group1 Col2

Group1 Col3

Group1 Col4

Group1 Col5

Group1 Col6

Group2 Col1

Group2 Col2

Group1 Col1 Col2 Col3

Col4 Col5 Col6

Group2 Col1 Col2

Hide duplicates in the group and sub total for each group. Possibly even put the totals in your table.

Cheers

😎

We are the pilgrims, master.
We shall go always, a little further.

Newbi SSCertifiable Points: 6546 More actions · Answer 7

Yup, I realised it is the only way to make a new dataset with formatted values , and call it from there. After that wrapped inside an empty table,setting the row limit then, it is working. 🙂