NVARCHAR

[SimonMills]

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

[kfleming]

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]

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]

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]

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]

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)]

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]

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]

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