Hi,

I've searched all over to find a solution to this problem but to no avail. CR is continuously adding stupid features which most people don’t need but does not fix bugs which go multiple versions back. Ahhhhhh!!!!!!!!!

In CR10, I added a couple of tables to my report, including a sub-report and when I attempt to verify I get the (Table not found) "...Proceed to remove this table from the report" message. Why is this problem occurring? How can I fix this? Can anything be done through the API to clear out db location information or what not?

Thank you in advance.

chris

Are you full of it? This will help - http://www.colondrano.com

It sounds like the verify is with a different database or user so either the object doesn't exist or the user doesn't have permission.

If you're adding tables to a report, a verify occurs at that time. Why and when are you using the Database->Verify Database?

Try using the Database->Set Location to repoint the table, the report will then ask if you want to propogate those changes across the otehr tables.

As for removing the server name, which might be your problem, you can manually remove it while in the Database->Set Location as the name is exposed as in:

MyServer.MyDBInstance.MyTable

Remove the Server portion.

Hopefully this resolves. If you need additional assistance, please also include the database type when asking about database connectivity.

-k

Thank you for your reply.

Yes, I've tried to update problem tables the database in the CR10 designer and I get this message:

Data Object cannot be opened/accessed. - Unknown Query Engine Error

When I print the report in the Designer it prints fine but the message "Table x not found. Proceed to remove this table from the report?" pops up.

I can't edit the location information as in CR85, not available in CR10.

Thanks
chris

Are you full of it? This will help - http://www.colondrano.com

I seem to recall there was a way to edit it in CR 10 as well, but it's different. Unfortunately I have CR 8.5 here...

What database and what connectivity are you using?

Not sure why I didn't ask that before...

These types of errors are fairly common when using the wrong connectivity, such as the Oracle supplied ODBC driver as opposed to the Crystal supplied Oracle ODBC driver.

-k

-k

Also, you can copy ther SQL generated from the Database->Show SQL Query and paste it into your query execution facility for the database and test what's going on there.

-k

There indeed is a way to edit the values... in the Set Datasource Location window (top half), expand properties, find the property you want to change (they vary depending on db/connectivity), press [F2], and enter the correct value.

Not all of the properties can be changed, but you should be able to set the database/server/etc...

-dave

Thanks for the help, guys

I'm using MSSQL 2000, the driver is the right one. The SQL is fine.

Can't really edit anything useful in the Set Datasource Location window. I've looked at the entire report object structure when it's loaded through the API and couldn't find anything in there that could be a problem, the database locations were OK. I did an ODBC SQL trace and looks like it's choking on catalog calls, I've heard there's a bug with that. Looks like I'll have to create reports in CR85, at least that thing has work arounds.

Thanks again!
chris

Are you full of it? This will help - http://www.colondrano.com

I'm curious as to how you looked at the locations to determine they're OK.  If, for instance, you looped through the DatabaseTables and checked the Location property, you might not really be seeing what's stored in the report.  When you read the Location from code, it only returns the table/procedure name, but the qualifiers might still exist.

The best workaround for that is to (and this seems silly, but works) set the Location equal to itself.  That will strip any qualifiers.

-dave

I checked the connection and database properties in each table. The problem tables had the exact same values as the old tables which are OK. The Location property in CR10 only contains the database table name.

hmmmmm..........
chris

Are you full of it? This will help - http://www.colondrano.com