Blank Fields

[Franklin_(Guest)]

I created a SQL report in version 10. The sql is a stored proc that returns a simple list of records to display. No grouping or anything like that. It worked on the DB I created it from, but when I try to change the datasource and run the report, the first two columns show up blank. The correct # of rows are there. I know because I can run the SP in QA and see the results I am looking for, but R&R doesn^t display them and doesn^t see them. What is wrong?

[kfleming]

What is the data type of the missing columns? My guess is that they are NCHAR or NVARCHAR and that you are using the MS SQL Server driver.____If you upgrade to Version 10+ the Data Direct SQL Server driver will work correctly for these data types.____Kathleen__R&R Support