I am connecting to 2 different datasources (SQL Server and MYSQL) in CR 2008. I am joing a SQL Server Stored Procedure to a MYSQL View on Date and User ID. (I am trying to retrieve the records for over 300 CSR's by day for a drill down report).
My problem is that even when using the stored procedure on the SQL Server side (Majority of the fields comes from the SQL server side) it takes an extremely long amount of time to populate the Crystal Report. Its almost as if Crystal runs both the SQL Server Stored procedure and then the MYSQL View and finally tries to match (link) the data in the Crystal interface record by record.
Am I doing something wrong or does anyone know of a different / more efficient way to get the data i need?
Any help would be greatly appreciated.
My problem is that even when using the stored procedure on the SQL Server side (Majority of the fields comes from the SQL server side) it takes an extremely long amount of time to populate the Crystal Report. Its almost as if Crystal runs both the SQL Server Stored procedure and then the MYSQL View and finally tries to match (link) the data in the Crystal interface record by record.
Am I doing something wrong or does anyone know of a different / more efficient way to get the data i need?
Any help would be greatly appreciated.