Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Data Connectivity
Message Icon Topic: Access Query as Db ? Post Reply Post New Topic
Author Message
Getch
Groupie
Groupie


Joined: 26 Dec 2008
Online Status: Offline
Posts: 47
Quote Getch Replybullet Topic: Access Query as Db ?
    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
IP IP Logged
Getch
Groupie
Groupie


Joined: 26 Dec 2008
Online Status: Offline
Posts: 47
Quote Getch Replybullet 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
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.033 seconds.