SSRS2005 report using data which contains carriage returns

• Bex

  SSCrazy

  Points: 2437

  More actions

  March 30, 2010 at 4:43 am

  #386605

  Hi

  I have a database with an address block of up to 4 lines stored in one field (carriage returns are stored). My problem is that I need to pull this data onto a report (SSRS 2005), retaining the structure of the address block (ie display address lines).

  Is there any way of doing this?

  Currently pulling the data from the database into a view, and have everything working just fine apart from this.

  Any help would be much appreciated.

  Hornet