SSRS how to add in New line

Question

I am creating a string from stored procedure like this Name1 , Name2 , Name 3.... etc(This string is in one column). I want to display these name in a new line in my SSRS report like

Name1
Name2
Name3

I tried changing the string to

Name1 VbCrlf 
Name2 VbCrlf  
Name 3

Doesn't seems to be working.

Please help me to resolve this issue.

score 25 · Accepted Answer · answered Aug 19 '13 at 06:51

25

Use an expression like:

=Replace(Field!Names.Value, ",", VbCrLf)

answered Aug 19 '13 at 06:51

Chris Latta

20,316
4
62
70

2

Good tip. This is how I used it in an expression to show the selections from a multi-value parameter. ="Name:" + VbCrLf + Join(Parameters!Names.Value, VbCrLf) – Tarzan Mar 18 '16 at 14:58

score 0 · Answer 2 · answered Oct 13 '16 at 08:01

0

="Name1:"+ Fields!name1field.Value + VbCrLf  +
"Name2:"+ Fields!name2field.Value + VbCrLf  +
"Name3:"+ Fields!name3field.Value + VbCrLf  +

answered Oct 13 '16 at 08:01

Avik

1
1

score 0 · Answer 3 · answered Jun 29 '17 at 13:40

0

I used this for displaying each multivalue parameter on a new line

=Join(Parameters!<YourMultiValueParameterNameHere>.Value, VbCrLf)

Hope this helps, Snelly.

answered Jun 29 '17 at 13:40

SnellyCat

156
1
10

score 0 · Answer 4 · answered Apr 29 '19 at 07:49

0

Please try this ="Name1:" & VbCrLf & "Name2:"& VbCrLf & "Name3:"& VbCrLf

answered Apr 29 '19 at 07:49

Mitul Panchal

592
5
7

SSRS how to add in New line

4 Answers4

Linked