Hopefully I can explain my issue with clear terminology, but I am fairly new to Crystal Reports so I apologize if this is cloudy.
I am attempting to run a report involving two separate databases on separate servers. One database (we'll call it the information database) gives information about a client while the other database (production database) gives financial production numbers for the salespeople belonging to that client. These two databases can be linked by joining their tables using the salesperson ID field.
My report output needs to show financial production which is grouped by client ID which is grouped by the client's state. This production should be given for the specified date range.
I am able to run two separate reports; one that gives salespeople by client state, and another showing financial production by salesperson for a date range. The production database report is able to sort through 250,000 records and run efficiently in this manner (around 15 - 30 seconds), while the information database can run its report quickly as expected. My issue comes when I combine these two reports in the fashion I mentioned above (financial production by client by state). The report slows to a crawl and is only able to process 500 records per second using my most successful attempt meaning that it takes between 8 to 10 minutes to run the full report. As expected, the total number of records processed grows only slightly from the production database report.
I have attempted using subreports, reordering links in many different ways, and trying a few other table joining techniques to see if any would speed up the report. What I want to know is, what is the best way to link these two databases that would yield the fastest accurate results?
Thank you!
Bluesky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.