all groups > sql server reporting services > september 2005 >
You're in the

sql server reporting services

group:

Unprintable ASCII characters failing reports?


Unprintable ASCII characters failing reports? bsg075 NO[at]SPAM gmail.com
9/23/2005 1:35:10 PM
sql server reporting services:
I have a report in SRS 2005 that is failing with an error because a hex
0X0b (ASCII(11)) character is in an NVARCHAR field.

Is there a way to allow the report to render, without altering the text
in the fields?
Re: Unprintable ASCII characters failing reports? Bruce L-C [MVP]
9/23/2005 3:47:36 PM
Have your query use Replace to replace that character with a space (or
nothing depending on what you want to do).


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

AddThis Social Bookmark Button