Solved

SSRS remove carriage returns

Posted on 2013-11-11
4
1,072 Views
Last Modified: 2013-11-15
Hi all,

I am trying to remove the carriage returns (annoying squares shown in the attachment) from my report.

Currently, I am trying to use the following expression to return the value:
=Replace(First(Fields!YourField.Value, "DataSource"),CHR(10),VbCrLf)

However, this is not working.

Can anyone please advise?

Thanks
Carriage-Returns.docx
0
Comment
Question by:FMabey
  • 2
4 Comments
 
LVL 5

Expert Comment

by:dannygonzalez09
Comment Utility
Can you post some sample text from the source table.. i want to give it a try

you can use this as a reference , if you don't have it already

http://www.theasciicode.com.ar/ascii-control-characters/carriage-return-ascii-code-13.html
0
 
LVL 65

Accepted Solution

by:
Jim Horn earned 500 total points
Comment Utility
Just a thought ...  If you're using stored procedures or views as the data source behind SSRS data sets, it would make more senese to 'scrub' CHAR(13) and CHAR(10)'s out in T-SQL using the REPLACE() function, then have to deal with them in SSRS.
0
 
LVL 3

Author Comment

by:FMabey
Comment Utility
Hi Jimhorn,

I've done just that. Thanks!
0
 
LVL 65

Expert Comment

by:Jim Horn
Comment Utility
Thanks for the grade.  Good luck with your project.  -Jim
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Written by Valentino Vranken. Introduction: The first step of creating a SQL Server Reporting Services (SSRS) report involves setting up a connection to the data source and programming a dataset to retrieve data from that data source.  The data…
A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now