bmilleridentco
Technical User
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 -
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 -