Print Page | Close Window

Connect Access to ERP?

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=966
Printed Date: 11 Apr 2025 at 7:47am


Topic: Connect Access to ERP?
Posted By: Rick
Subject: Connect Access to ERP?
Date Posted: 04 Jul 2007 at 12:38am
Hi, I've got a database connection problem. We use an ERP-system (Improve), in which all (financial) transactions are stored. This database does not come with a proper budget function, however. So, I've made an Access database with the budget (per article and per customer). Keys are identical.
Unfortunately, CR gives me an error because I use two different database sources. When I want to make the report anyway, CR crashes.
 
I would rather not use a subreport and variables. Is there a way to connect these 2 databases? Thanks!


Print Page | Close Window