Converting NVARCHAR issue

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

[kfleming]

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