Microsoft SQL Server
-
- Posts: 1
- Joined: Tue Oct 10, 2017 12:44 pm
Microsoft SQL Server
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 ?:-)
=> RE: Microsoft SQL Server
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