NVARCHAR

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

NVARCHAR

Post by SimonMills » Wed Jul 23, 2008 7:38 am

Hi, can R&R read NVARCHAR fields yet from SQL 2000?__

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

=> RE: NVARCHAR

Post by kfleming » Fri Jul 25, 2008 8:13 am

Not directly but you can create a calculated field with the expression:__sqlexp("convert(char(n),fieldname)")____where n is the length of the field and fieldname is the NCHAR field from the table, you will be able to see your data.____Kathleen__R&R Support

KenB
Posts: 19
Joined: Tue Oct 10, 2017 12:44 pm

==> RE: NVARCHAR

Post by KenB » Wed Feb 11, 2009 9:58 am

Has anything changed with this type of field? we just started using a service/repair program (AYS) that has all text fields as this type. Very cumbersome to use this for each field.

KenB
Posts: 19
Joined: Tue Oct 10, 2017 12:44 pm

==> RE: NVARCHAR

Post by KenB » Thu Feb 12, 2009 9:58 am

In using your calculated field syntax, I get an error message that states "The SQLEXP() function is not supported in user-SQL reports.____This is really unacceptable. What is everybody doing to read these fields?____

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

===> RE: NVARCHAR

Post by kfleming » Fri Feb 13, 2009 9:59 am

If you are using a User SQL report then you simply need the expression:__convert(char(n),fieldname)____in your SELECT list. ____You would use SQLEXP if you are using a calculated field within a report so that the SQLEXP expression would be evaluated by the server.______Kathleen__R&R Support

SimonMills
Posts: 3
Joined: Tue Oct 10, 2017 12:44 pm

====> RE: NVARCHAR

Post by SimonMills » Sun Mar 08, 2009 8:50 pm

I still don^t understand what you mean about selecting the fields, can you be more explicit. I have no problem selecting nvarchar fields, but they print as if they contain blanks.____Don^t force me to buy a copy of crystal reports!

Chris_Strasser_(Guest)
Posts: 47
Joined: Tue Oct 10, 2017 12:44 pm

=====> RE: NVARCHAR

Post by Chris_Strasser_(Guest) » Mon Mar 09, 2009 4:21 pm

I believe that she^s referring to a User-SQL report where you^d explicitly lay out your SQL selection statement:____SELECT field1, field2 from table1 where field1 = "X" order by field2______Or something to that effect. You^d put the calculation Kathleen noted in place of one of the fieldx terms following the select.____A User-SQL report is defined when you first go to create the report:____File / New User SQL

SimonMills
Posts: 3
Joined: Tue Oct 10, 2017 12:44 pm

======> RE: NVARCHAR

Post by SimonMills » Thu Sep 24, 2009 12:31 pm

I^ve sort of managed to make that work, but I^m stuck on how to get another table and link to it using the field made from the NVARCHAR field.

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

=======> RE: NVARCHAR

Post by kfleming » Fri Sep 25, 2009 10:05 am

You should be able to link directly using the field from the table rather than needing to use the calculated field.____Kathleen__R&R Support

Post Reply