I am doing a report and have tried it two different ways. One using the crystal report gen in VS and the second using Crystal Reports V10. Both are extremly slow to populate the data on the report. I think part of the problem is that the report queries 2 different databases. Crystal generates the queries like this:

SELECT "PersData"."Employee_Number", "PersData"."Last_Name", "PersData"."Initials", "PersData"."Squadron"
FROM "TrainingManagementDB"."dbo"."PersData" "PersData"
ORDER BY "PersData"."Squadron"


SELECT "CP"."DateIssue", "CP"."Deficiencies", "CP"."CPID", "CP"."SN"
FROM "Discipline"."dbo"."CP" "CP"

Is this a design problem? Should the tables be in the same database? How do I speed this up? Can I use a join statement between 2 different databases when they have a common column? Employee_Number is the primary key in the persdata table and SN is the same number in the CP table. Help please.