Skip to Content
0
Former Member
Feb 24, 2011 at 10:28 PM

How do you link an Excel file to a SQL table within Crystal Reports XI

114 Views

I am trying to create a report that uses data from an Excel file and a SQL table. I can successfully pull data into the report using only the Excel file or only the SQL table, but if I try to link the Excel file with the SQL table I receive the following message after the objects are linked together in the Database Expert.

More than one database driver has been used in this report. If you want to change the database drivers use Database/Set Location. Please make sure that no SQL Expression is added and no server-side group-by is performed.

There are no SQL expressions in the report and no server-side group-by is being performed.

Any ideas on how to resolve this issue?