Need new line in SSRS matrix

Question

I have the data int this format in our database -

Item1                            Item2
Processor   Intel i7-4558U  3.30GHz Intel i7-4500U  1.80GHz Intel i5-4200U  1.60GHz
Processor   Intel Atom™ N2600  1.60GHz
Processor   Intel i7-2670QM   Intel i5-2410M   Intel i3-2330M   Intel B950/B940

and in SSRS matrix report , I want to change the data in this format -

Processor Intel i7-4558U  3.30GHz
          Intel i7-4500U  1.80GHz
          Intel i5-4200U  1.60GHz
Processor Intel Atom™ N2600  1.60GHz
Processor Intel i7-2670QM   
          Intel i5-2410M 
          Intel i3-2330M  
          Intel B950/B940

Thanks for any help.

Showing in it matrix is easy. The task you have to do is splitting the values from the column item2. You have to write your sql in that way. — Aditya
Thanks Aditya, Yeah If I am not able to achieve this in SSRS then I will handle this in SQL. — Wumar

Ron Smith Ron Smith · Accepted Answer · 2014-04-11T18:19:58

You don't need to update your SQL. Just replace the spaces before Intel with a vbcrlf:

=replace(Fields!Item2.Value," Intel",vbcrlf & "Intel")

enter image description here

Let me know if this helps or if I can help you further.

Need new line in SSRS matrix

1 Answers