Converting NVARCHAR issue

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
Jedw
Posts: 1
Joined: Tue Oct 10, 2017 12:44 pm

Converting NVARCHAR issue

Post by Jedw » Wed Oct 05, 2011 5:37 pm

__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"__

kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

=> RE: Converting NVARCHAR issue

Post by kfleming » Sun Oct 23, 2011 8:26 pm

You need to convert to varchar instead of nvarchar__Select__Convert(varchar(50),CustomerName)__from__"dbo"."Customers"____Kathleen__R&R Support

Post Reply