ssrs 2008 r2 concateante values into one cell

• wendy elizabeth

  SSCoach

  Points: 16915

  More actions

  November 3, 2013 at 9:27 am

  #300726

  In an sql server 2008 r2 report, I have one textbox that I need to concantenate values together. I then need to concatenate the values together to display in one cell that looks like the following:

  1. Company number

  2. 5 spaces

  3. company number that is varchar(5)

  4. 5 spaces

  5. company name

  6. 5 spaces

  7. company number that is varchar(30).

  Thus can can you show me how to display the values in the order the customer wants to see them in the one cell?

• robert.gerald.taylor

  SSChampion

  Points: 13133

  More actions

  November 3, 2013 at 7:13 pm

  #1663715

  Look at string concatenation in SSRS: http://www.katieandemil.com/ssrs-concatenate-two-string-fields-using-expression#article

  Keep in mind, the you can concatenate the vbCRLF built in constant to get a carriage return/line feed.

  HTH,

  Rob

• ndiro

  SSC Eights!

  Points: 892

  More actions

  November 12, 2013 at 1:59 am

  #1665654

  if you are working with ssrs2008 or greater you can do this:

  1) Create a Paceholder for you textbox

  2) In Paceholder poperties enable "HTML - Interpret HTML tags as style"

  3) In "Value" set ="<ul><li>Fields!Field1.Value</li><li>Fields!Field2.Value</li>....<li>Fields!FieldN.Value</li></ul>"

  That's all