Join two Databases

[blueboyz]

Hi:

I'm using Crystal Reports 2008 for Peachtree. Sage 50 Premium 2013 and database engine is Pervasive SQL.

I created an annual sales report in Crystal Reports. The customer created a new company in Sage 50 Premium 2013 and they want to combine the transactions for both the old and new company into the custom crystal report created for annual sales.

Do you know how to combine two companies from Sage 50 Premium 2013 into one report?

They need the transactions from last year in the old company plus the new company’s transactions this year in their one report for sales.

Thank you.

 

[PeterDimitrov]

You can check this discussion:

http://www.tek-tips.com/viewthread.cfm?qid=1725106

Access is just an example, you will get better results if you use SQLServer as a proxy. You can add Sage 50 as linked server and query it using SQLserver.

http://www.R-Tag.com

Viewer and Scheduler for Crystal reports, SSRS and Dynamic Dashboards.

 

[blueboyz]

Thank you, I'll take a look at that post.