Crystal Reports returning no data sql server

I have Crystal Reports 2016, desktop version and connect to two different SQL Servers. I connect via System ODBC to both servers.

SQL Server version 12.0.2269.0 shows data in the report when running/previewing.

SQL Server 12.0.5540.0 does not show data in report when running/previewing (but connects and columns/views are visible).

How can I get Crystal Reports connecting to SQL Server 12.0.5540.0 to display data in reports.

former_member292966 · ‎2018 Mar 14

Hi Joe,

Are you trying to change from one database to another?

If you are, make sure you go to Database | Set Datasource Location and have all of the tables in the report point to the new server.

If you create a new simple report against the second database, do you see records?

Check to make sure the ODBC datasource for the second database is 32 bit. Crystal is a 32 bit application and can't use a 64 bit ODBC datasource.

Brian