This isn't the ideal category/forum for this message but it was the closest.

A co-worker using Crystal Reports 7.0 and SQL Server 2000 (via OLEDB) was designing a report. Some of the fields were not available for her to group/sort by. She was using nvarchar types for most of the fields and once we switched them to char types the reporting worked fine. I found something on Crytal about unicode types not working from SQL 7.0 but it was a different type of error. Has anyone else had similar problems using Crystal and SQL? Thanks.