Liveware Publishing Support Forum

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?

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