1

The expression currently used to populate the cell in the report is as follows:

=Fields!SomeDataFromSQL.Value

Now the value of that .Value is something like below:

Image01 Image02 Image03 Image04

I would like for these to appear in the report as new line items for readability:

Image01
Image02
Image03
Image04

How can I build this into the query?

PnP
  • 3,133
  • 17
  • 62
  • 95
  • either you should use `Environment.NewLine` OR `="Image01" & vbcrlf & "Image01" OR `CHR(13)` in your sql query – Pedram Jan 30 '16 at 18:28
  • If I put that into my SQL cell, in the report it just appears as exactly as you put it there: ="Image01" & vbcrlf & "Image01" – PnP Jan 30 '16 at 19:02
  • 1
    Instead of that, you can use
    in SQL query and use placeholder to set value. Also check radio button of html text inside placeholder properties... It will definitely work     – Pedram Jan 31 '16 at 02:22
  • Possible duplicate of [SSRS how to add in New line](http://stackoverflow.com/questions/18306328/ssrs-how-to-add-in-new-line) – Chris Latta Feb 01 '16 at 00:02

0 Answers0