Go Back   Access World Forums > Apps and Windows > Crystal Reports

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 11-11-2014, 08:21 PM   #1
Kiz
Newly Registered User
 
Join Date: Nov 2014
Posts: 11
Thanks: 1
Thanked 0 Times in 0 Posts
Kiz is on a distinguished road
Accessing Crystal Reports through MS Access

Hi all,

I am using MS Access 2010, building my first ever access database. I have worked out how to pull data from excel however, I am now trying to pull data from Crystal Reports 10. I am using the ODBC button, however I keep getting an error, along the lines of "need to install driver". Aaaaand i have no idea what this means! Any help?

Thanks all!

Kiz is offline   Reply With Quote
Old 11-12-2014, 01:28 AM   #2
Minty
AWF VIP
 
Minty's Avatar
 
Join Date: Jul 2013
Location: UK - Wiltshire
Posts: 3,958
Thanks: 74
Thanked 1,071 Times in 1,047 Posts
Minty will become famous soon enough Minty will become famous soon enough
Re: Accessing Crystal Reports through MS Access

If Crystal Reports is connected to a data source to generate it's output, why not connect access directly to the same data source? Or am I missing something...
__________________
A little thanks goes a long way
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

(Please use the scales on the left if we have helped!) Mark threads as Solved once you have an answer.

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Minty is offline   Reply With Quote
Old 11-12-2014, 09:16 AM   #3
kevlray
Newly Registered User
 
Join Date: Apr 2010
Location: Central California
Posts: 533
Thanks: 6
Thanked 48 Times in 46 Posts
kevlray will become famous soon enough
Re: Accessing Crystal Reports through MS Access

I am confused also. So are you trying to access an Crystal Report through Access (not sure this is possible with out some VB code)? Or are you trying to use Access 2010 as a data source? Should be possible if you create an ODBC connection to the Access 2010 database (I do not use CR 10 anymore, so I am not sure. It does work with CR 2011).

kevlray is offline   Reply With Quote
Old 05-21-2015, 05:57 AM   #4
Minty
AWF VIP
 
Minty's Avatar
 
Join Date: Jul 2013
Location: UK - Wiltshire
Posts: 3,958
Thanks: 74
Thanked 1,071 Times in 1,047 Posts
Minty will become famous soon enough Minty will become famous soon enough
Re: Accessing Crystal Reports through MS Access

What type of error is being generated and at what stage of the process?
How have you tried connecting.

More information required to be able to help.
__________________
A little thanks goes a long way
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

(Please use the scales on the left if we have helped!) Mark threads as Solved once you have an answer.

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Minty is offline   Reply With Quote
Old 07-08-2016, 05:59 AM   #5
ElenaGilbert
Newly Registered User
 
Join Date: Jul 2016
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
ElenaGilbert is on a distinguished road
Re: Accessing Crystal Reports through MS Access

There are a bunch of database access DLLs that you can choose to install when you install crystal, you may want to check that you have the correct database access files installed.
It maybe depreciated by MS but I find using the ODBC drivers works better with older file types. (I'm sure some one will tell me off for recommending this, but I guessing its not a mission critical report you are looking at)

ElenaGilbert is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Crystal Reports in Access Paul_birm Reports 3 07-28-2008 11:15 PM
PEOpenEngine() API calls in crystal reports xi/ crystal reports 2008 sumita2008 Crystal Reports 0 04-07-2008 10:31 AM
Access or Crystal Reports snowsride General 4 01-22-2008 09:24 AM
Access with Crystal reports.. Bosch General 6 05-12-2006 02:21 PM
Crystal Reports and Access 97 Baldrick Queries 1 12-06-2001 10:12 AM




All times are GMT -8. The time now is 08:44 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World