SQL Expression functionality

[beebass]

I currently use CR9 and have a report showing the number of sales invoices invoiced by month to each customer. The report is set up using an SQL expression on the invoice date so that it only pulls data for the financial year (Nov to Oct). However, I've been tasked with regionalising this sales data based on the location of the customer. I have an Access table that contains a region for each customer and so have linked it to the report. Unfortunately when doing this the following message is displayed and the report takes an extremely large amount of time to run:

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

Is there a way around this?

Thanks

BB

 

[synapsevampire]

Linking different data sources in Crystal forces Crystal to operate as your database, hence it's slow.

You mention the one database as Access, what's the other?

You can link (notimport) the other database into the Access database and build an Access query as the source for the report, that will prove much faster.

-k