Print Page | Close Window

Change data source in Crystal Report

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=21343
Printed Date: 16 May 2024 at 8:16pm


Topic: Change data source in Crystal Report
Posted By: thummel1
Subject: Change data source in Crystal Report
Date Posted: 19 Feb 2015 at 5:36am
Hi, I'm working on CR 2008. I have a report that pulls data from an ODBC connection as well as an Access table from MS Access. The table from MS Access is quite large, about 1600+ rows of data.
 
My goal: I no longer want my report to reference this MS Access table because it prevents me from loading this report into Lawson Business Intelligence (LBI) because MS Access is not an aproved Data Source, unlike our ODBC connection. Is there a way to take this Access table, and incorporate the data into my existing report (in some simple way) so that I can stop this connection to MS Access? I've been exploring the CR Respository feature but it looks like we need an ODBC connection to that as well and some behind the scenes server set up for that option to work.
 
Any suggestions would be appreciated, thanks!


-------------
"Press any key to continue. Where's the 'Any' Key?" ~Homer Simpson


Replies:
Posted By: kevlray
Date Posted: 20 Feb 2015 at 5:35am
Short of exporting the data into an accepted source (I do not know what you have available).  FYI- There are free versions of MS-SQL Express available.  There is a size limitation of the data (the last I remember is 4GB).  I hope this helps.


Print Page | Close Window