Page 1 of 1

Converting NVARCHAR issue

Posted: Wed Oct 05, 2011 5:37 pm
by Jedw
__I am using the instant report option. When I preview the report, I can see the column names. However the report doesn_t d display all of the field values. Looking the field formats I noticed the issue seems to be with fields formatted as NVARCHAR. I found a post that states NVARCHAR fields need to be converted to straight Char format. So I am keeping it simple and just trying to get one field to show on the report. I have tried using the following SQL Statement; however the report still doesn_t display the value. Can any tell me what I am doing wrong? Thank you. ____Select__Convert(nvarchar(50),CustomerName)__from__"dbo"."Customers"__

=> RE: Converting NVARCHAR issue

Posted: Sun Oct 23, 2011 8:26 pm
by kfleming
You need to convert to varchar instead of nvarchar__Select__Convert(varchar(50),CustomerName)__from__"dbo"."Customers"____Kathleen__R&R Support