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:
Hello,

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.
Thanks
ASKER CERTIFIED SOLUTION
LinInDenver

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