Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
2 posts • Page 1 of 1
__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"__