Liveware Publishing Support Forum

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

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

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.

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?____

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

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!

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

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.

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