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!

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

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

Status
Not open for further replies.
nefariousgeek

nefariousgeek

Programmer
Joined
Aug 9, 2005
Messages
4
Location
CA
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 -
 
Sort by date Sort by votes
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
 
Upvote 0 Downvote
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 -
 
Upvote 0 Downvote
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
 
Upvote 0 Downvote
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
 
Upvote 0 Downvote
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
 
Upvote 0 Downvote
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 -
 
Upvote 0 Downvote
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
 
Upvote 0 Downvote
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 -
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

H
  • Locked
  • Question Question
Cannot get a sub-report to print without the headers and footers of the main report
Replies
1
Views
424
DjangMan
DjangMan
JustMe24
  • Locked
  • Question Question
How to select from 2 rows in a table
Replies
1
Views
719
SoftwareRT
SoftwareRT
D
  • Locked
  • Question Question
Open a report into Design mode
Replies
0
Views
398
drb1980
D
K
  • Locked
  • Question Question
We're using command in crystal report
Replies
1
Views
778
hilfy
hilfy
David Richardson
  • Locked
  • Question Question
Adding BLOB Fields to Reports in Crystal Reports Professional 8.5
Replies
7
Views
1K
hilfy
hilfy

Part and Inventory Search

Sponsor

Back
Top