none
SSRS 2008 r2 concatenate values in one cell

    Question

  • 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?

    Sunday, November 03, 2013 4:26 PM

Answers

  • hi 

    you can use 

    =First(Fields!Companynumber.Value, datasetname)+"     "+First(Fields! company number.Value, datasetname)+"     "+First(Fields! company name.Value, datasetname)+"     "+First(Fields! company number.Value, datasetname)

    • Proposed as answer by mhm_2004de Sunday, November 03, 2013 6:25 PM
    • Unproposed as answer by mhm_2004de Sunday, November 03, 2013 6:25 PM
    • Marked as answer by wendy elizabeth Monday, November 04, 2013 2:03 AM
    Sunday, November 03, 2013 5:32 PM

All replies