Skip to Content
0
Former Member
Oct 13, 2009 at 02:07 PM

Set Datasource location in Crystal XI not working

519 Views

I have what seems to be a common problem with the setting of a datasource in Crystal XI designer.

I am converting my Crystal 8.5 reports to crystal XI.

The connection I am using is an OLE DB(ADO) connection to SQL Server 2005.

When I try to change the Datasource from a test database to a production database, absolutely nothing happens.

The data displayed on the report is the data from the database from which the report was designed.

I have scoured the internet and have found numerous complaints about this issue.

The only semi-acceptable solution I have found is that you have to go into the properties of each table on the report (including subreports) and change the Overridden Qualified Table Name by typing in the name of the table.

Is this the only solution?

I have over 300 reports. Many with subreports.

How archaic is this?

Is there at least some sort of conversion program available that would help me with my existing reports.

I have no problems during runtime. It is only the designer with which I am having an issue.

Any help is appreciated.

Leonard

Edited by: Leonard Mann on Oct 13, 2009 4:25 PM

Edited by: Leonard Mann on Oct 13, 2009 5:23 PM