CODEWITHSUNDEEP
sqlvisual-studio-2012reporting-servicesssrs-2012
user3654442
user3654442

Reputation: 195

SSRS displaying columns on a matrix to the right

I have a table that looks like so:

enter image description here

Is there any way I can display it like this in SSRS?

      1        2       3      4
1    2.091    0.918   0.9   1.718
2    0.647    0.964   0.6   2.264
3    0.804    0.789   0.6   1.9

I tried using a matrix but it stops after showing the first column and doesn't expand to show the rest.

Attempt:

enter image description here

Results:

enter image description here

Another attempt:

enter image description here

Results:

enter image description here

Upvotes: 0

Views: 303

Answers (3)

Kostya
Kostya

Reputation: 1605

to get something similar to the result you're looking for you need to write a query like:

select id
,row_number() over(partition by SubscaleNumber  order by SubscaleNumber ) SubscaleNumber 
, item 
 from yourtable

enter image description here

then the matrix should work fine.

enter image description here

Upvotes: 1

StevenWhite
StevenWhite

Reputation: 6024

You need to set the Row and Column grouping to get this matrix-style output.

enter image description here

When you click in your table you should see the brackets for the Row and Column groups. If you don't have a column group, add one.

Go into the properties of each group and make sure they are grouped by the column you want.

Upvotes: 1

Ross Bush
Ross Bush

Reputation: 15155

Start from scratch with a table or matrix.

  1. Add a Row group on id
  2. Add a Column Group on Item.

Upvotes: 0

Related Questions