Cannot change Datasource Location in Crystal Reports 2008
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
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
I'm trying to replace an SP with another SP.
Sorry for confusion.
Thanks
Sorry for confusion.
Thanks
ASKER
Here is a screen shot of what's happening
cr-ds-update-problem.JPG
cr-ds-update-problem.JPG
Can you create a new report with that SP?
mlmcc
mlmcc
ASKER
Yes, I can. And I can do it even in this report, but I will have to manually replace all fields in the report to point to this new Data Source.
Thanks
Thanks
If you select the new SP from the bottom block can you click UPDATE?
Does that change to use the new SP?
I don't use stored procedures so I haven't had a reason to change bwtween 2. I don't have a database that has stored procedures so I can't try it myself
mlmcc
Does that change to use the new SP?
I don't use stored procedures so I haven't had a reason to change bwtween 2. I don't have a database that has stored procedures so I can't try it myself
mlmcc
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you for your replies
2 mlmcc - yes I can click Update, but that will bring this "Data Object cannot be opened/accessed" error :( and will not change anything. I figured out how to change the data base/source - I need to run the report and it will prompt me to specify a new ODBC, where I can select the one I need. That will update it. But it will not update the stored procedure and I couldn't find a way to change it. Even if they're of the same name, the catalog and the db owner would still be old ones, preventing the report from running :(
2 LinInDenver - man, this sux big time :((( I have ~70 reports I need to convert from one environment to another. I cannot change all fields to formulas now. I have managed to fix one report by manually assigning a new data source for each field, but that was a small report. I have reports with tens and tens of fields and up to 3-4 groups and all formulas inside...
I talked to a guy who managed to change it for some procedures before. And for him it worked just as it was supposed to work - select one, select another and click update. He even didn't remember clearly any particulars as it went smoothly. To our knowledge, everything was the same in his case (he was a contractor), including databases, test version of CR, and everything else I can think of.
I hope someone will have an answer to this :(
Thanks
2 mlmcc - yes I can click Update, but that will bring this "Data Object cannot be opened/accessed" error :( and will not change anything. I figured out how to change the data base/source - I need to run the report and it will prompt me to specify a new ODBC, where I can select the one I need. That will update it. But it will not update the stored procedure and I couldn't find a way to change it. Even if they're of the same name, the catalog and the db owner would still be old ones, preventing the report from running :(
2 LinInDenver - man, this sux big time :((( I have ~70 reports I need to convert from one environment to another. I cannot change all fields to formulas now. I have managed to fix one report by manually assigning a new data source for each field, but that was a small report. I have reports with tens and tens of fields and up to 3-4 groups and all formulas inside...
I talked to a guy who managed to change it for some procedures before. And for him it worked just as it was supposed to work - select one, select another and click update. He even didn't remember clearly any particulars as it went smoothly. To our knowledge, everything was the same in his case (he was a contractor), including databases, test version of CR, and everything else I can think of.
I hope someone will have an answer to this :(
Thanks
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
It seems it was our version of Crystal Reports or our environment or something at our location. I went to our another branch and tried there and it was all fine :( It still behaves inconsistent at times, but seems to be working after a number of tries... We're moving mid-January to a new location where presumably everything should be installed and setup properly, I'll see if it works there and meanwhile will accept your answers guys. Thanks.
I don't think Crystal can do that.
mlmcc