troubleshooting Question

Cannot change Datasource Location in Crystal Reports 2008

Avatar of Yurich
YurichFlag for New Zealand asked on
Crystal Reports
10 Comments2 Solutions5007 ViewsLast Modified:

I'm using a trial version of Crystal Reports 2008 and I'm trying to change the datasource location for an existing report in CR 2008 and the way I do it is not working.

That's what I do:
- Select in menus - Database -> Set Datasource Location
- Select my current data source
- Select one of my connections in Replace with
- Click Update
- Get the error: Some tables could not be replaced, as no match was found in the new data source. Please specify the table required for any unmodified tables.

- Then, I'd select my "table" (which is a stored procedure in fact) in the Current Data Source
- Drill down in the connection I need to use and select a stored procedure I'd like to use
- Click Update
- Get the error: Data Object cannot be opened/accessed
- Get another error right away: Unknown Database Connector Error

ODBC is fine and everything works. If I add a new SP to a report, it will work fine, but if I remove an existing stored procedure, all fields will disappear. I have tried numerous scenarios, but the outcome is always the same :(

Would appreciate a help on the matter.

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 10 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 10 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros