Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

ssrs 2008 r2 concateante values into one cell Expand / Collapse
Author
Message
Posted Sunday, November 3, 2013 9:27 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, July 22, 2014 8:17 AM
Points: 362, Visits: 422
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?
Post #1510901
Posted Sunday, November 3, 2013 7:13 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 2:47 PM
Points: 1,163, Visits: 1,187
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
Post #1510961
Posted Tuesday, November 12, 2013 1:59 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, July 18, 2014 1:24 AM
Points: 44, Visits: 206
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
Post #1513363
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse