# Solution

Example :

Consider below query is my dataset :

`DECLARE`  `@sample_data ``table`
```( ```
`Name` `varchar````(50), ```
```AgeYears ````INT````, ```
```WeightPounds ````INT````, ```
```HeightInches ````INT`
```) ```
`insert` `@sample_data ``SELECT`  `'Anna'``,84,90,60 `
`insert` `@sample_data ``SELECT`  `'sarah'``,38,120,67 `
`SELECT` `* ``FROM` `@sample_data`

If we need columns `AgeYears`,`WeightPounds`,```HeightInches horizontally stacked in one row cell: ```

Add a Matrix, under Rows add Name field and then Insert Row -> Inside Group -  Below as shown in below image. Similarly add two more rows.

Under Columns -> Data : below is the expressions for three inserted rows:

`=``"Age"``+Space(3)+``CStr````(Fields!AgeYears.Value) ```
`=``"Weight"````+Space(3)+Cstr(Fields!WeightPounds.Value) ```
`=``"Height"````+Space(3)+Cstr(Fields!HeightInches.Value) ```

After formatting and alignment, if we click on Preview tab we can notice the expected report as shown in below image:

If we don't need lines in between Age, Weight & Height then add Tablix with two columns Name and Stats.
With Name value=Fields!Name.Value
& Stats Value  ="Age " + Cstr(Fields!AgeYears.Value) + VBCRLF + "Weight " + Cstr(Fields!WeightPounds.Value) + VBCRLF
+
"Height " + Cstr(Fields!HeightInches.Value)

After formatting and alignment, if we click on Preview tab we can notice the expected report as shown in below image: