Smart questions
Smart answers
Smart people
Join Tek-Tips Forums
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login




Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

Join Tek-Tips
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.
Jobs from Indeed

Link To This Forum!

Partner Button
Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

CR10 "...Proceed to remove this table from the report" message

nefariousgeek (Programmer) (OP)
9 Aug 05 14:27
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

synapsevampire (Programmer)
9 Aug 05 14:37
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
nefariousgeek (Programmer) (OP)
9 Aug 05 15:07
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

synapsevampire (Programmer)
9 Aug 05 15:40
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
synapsevampire (Programmer)
9 Aug 05 15:41
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
vidru (Programmer)
9 Aug 05 15:44
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
nefariousgeek (Programmer) (OP)
9 Aug 05 16:07
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

vidru (Programmer)
9 Aug 05 16:17
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
nefariousgeek (Programmer) (OP)
9 Aug 05 16:24
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

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close