Microsoft SQL Server

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

Microsoft SQL Server

Post by Glen_Farrell_(Guest) » Wed Jun 12, 2002 11:01 am

I am using RR 8.1 SQL version connecting to a SQL Server table. I connect select my database and create a simple report with a fields. When I preview the report I don^t have information for some of the fields of the database/table. When I create a ODBC link in Access 97 to this table, all fields have data. My question is, why does R&R 8.1 not display the data the same as MS Access 97 ?:-)

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

=> RE: Microsoft SQL Server

Post by kfleming » Thu Jun 13, 2002 8:04 am

My guess is that your fields are NCHAR or NVARCHAR data type.__These data types cause exactly this problem in R&R.____Kathleen__R&R Support

Post Reply