Hi, Using SSRS 2005 and I am trying to include a field in a report where the users will often leave multiple CRLF on the end. It is a delivery instructions field in the database. This has the effect of leaving big white space between records in my report. I tried using the trim() function but that didn't work and after researching I realized that trim() only works with the space character. Any suggestions on how to trim something other than the space character? Thanks in advance, Linn

Hi There You can use the following expression inside SSRS =Replace(Fields!ID.Value,Chr(10),"") For your reference I am putting screenshot. If you have any questions please do ask. Many Thanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful. =Replace(Fields!ID.Value,Chr(10),"")