Print Page | Close Window

Access Query as Db ?

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
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=16863
Printed Date: 28 Apr 2024 at 9:37pm


Topic: Access Query as Db ?
Posted By: Getch
Subject: Access Query as Db ?
Date Posted: 27 Jun 2012 at 3:58am
Hi All,
 
I've never tried this until now and it appears I cant use an Access Query as the database for a crystal report.
 
Is this accurate?
 
As a little background, I have several large history Access DB's with identical tables. I was thinking I could create a union query and use that query as the DB for a crystal report in order to pull all the data together in a single report.
 
Can this be done? If so, any trick to doing so? I'm getting an odd error when I attempt to set the DB. Crystal is telling me the DB does not exist.
 
I'm adding a new connection and browsing direct to the DB so it does exist.
 


-------------
Newbie reports


Replies:
Posted By: Getch
Date Posted: 27 Jun 2012 at 5:25am
NM,
 
Worked it out.
ran my query, then imported the query as a new table. assigned new table as the data source.
 
If there is an easier way, would love to hear it!


-------------
Newbie reports


Print Page | Close Window