No data returned from Crystal XI after upgrade from Crystal 8.5
I've opened & saved reports in the XI version, but when I do a preview of data all I get is the headings - no data. Any suggestions?
I'm connecting to a Sybase 12.5 database using a Sybase ASE ODBC driver (syodase.dll). When I do a test connection I am fine.
If I make the report over from scratch I get data along with the headings. I would really like to NOT re-create all the reports we have currently in crystal 8.5 so I'm hoping someone has an answer for me.
Thanks for any help you can provide,
Wallie Cheng replied
Since the report was created in CR8.5, in CRXI please go to Database|Show SQL Query. If the Reset button is enabled, please reset the query and try refreshing the report again.
In previous version of Crystal Reports the Show SQL Query section was only meant to only be viewed and not modified. If it was modified, this could be causing the issue.