Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Converting report from 8.5 to 10.0

Status
Not open for further replies.

bmilleridentco

Technical User
Oct 9, 2008
10
US
I'm converting a report used in Crystal 8.5 to 10.0. I'm also changing the database location. After going through the Set Datasource Location routine and changing the links in the subreports, I'm still getting a "failed to open a rowset" error message. The message shows an invalid object name of PS11_0_1.dbo.BBJTHEAD. Now this is the name/location of a table from the old report. I have looked at every table in the new report and the properties show the correct new database name/location of all the tables.
I just can't figure out why the report is trying to reference this old location. By the way, if I copy the query from SHOW SQL QUERY into Query Analyzer, I get a correct return of fields.
Thanks very much if anyone has any ideas on this.
- BOB -
 
Hi,
I believe ( don't have my CR handy) The when setting the data source there is an option about using the default table name prefix- check to see if that is what is causing the problem.

BTW, even when changed, the report will still use the old names for the table(s) so that any formulas will still compile.



[profile]

To Paraphrase:"The Help you get is proportional to the Help you give.."
 
Hi Turk,
Thanks for taking the time to respond. I've checked the formulas and they appear to be using the new data tables.
What I don't understand is that the query works in Analyzer and I don't see any reference to the old table in the query.
Thanks again
- BOB -
 
Are you using Stored Procedures or SQL Commands? Methods are different from 8.5 to 10. We did that upgrade and it was necessary to save the SQL as text and re-insert it in Crystal.

[yinyang] Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10 [yinyang]
 
Try doing an export to report definition.

Then search the resulting .txt file for PS11_0_1.dbo.BBJTHEAD might tell you where it is trying to be used.

Could be hidden in a suppression or format rule.

Ian
 
Thank you for the suggestion Ian,
The export failed because of the "failed to open rowset" error message. Thanks though for taking the time to help.

- BOB -
 
Hello Madawac,
Thanks for the reply. I believe it's all SQL commands. I'm not sure I know what you mean by saving the SQL as text and reinserting...How did you do that ?
Thanks again
 
Bob

I am surprised Export Reeport Definition does not work as it does not usually make a call to the database. I have had reoprts failing due to unknown field and I still get a report definition.

Which version of CR are you using?

Ian
 
In 8.5, find the SQL commands and paste them into text files.

Do versions of the 8.5 reports without the SQL. Upgrade to 10.

Re-add the SQL. Choose Database > Database Expert. Click on the warehouse. You should see Add Command at the top of the 'tree'. To change, right-click and choose 'Edit Command'. Paste in the code.
You'll find also that 'Command' can link to regular tables, a big improvement.

If you're actually using SQL Expression Fields, the soluition is similar but you should just request a new one and then post in the code.

[yinyang] Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10 [yinyang]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top