Solved

Crystal Reports - The database table cannot be found. proceed to remove this table from the report?

Posted on 2011-03-07
5
2,679 Views
Last Modified: 2012-06-21
Hi all,

We have been getting the error;

"The database table "Table_name" cannot be found. proceed to remove this table from the report?

When doing a preview of some reports we have written.  if you select no the report completes no problem, however the issue is we need to publish tese reports to out Business Objects server in InfoView and therefor the rports do not run.

I have discovered the error only occurs with table names that exceed 27 characters.

Any one have a solution, is there someway of creating alias names for the tables.  We have tried renaming the table in Database Expoert but the error remains.

Using Crystal Reports 2008 connecting to a Pronto ERP system.

Cheers!


0
Comment
Question by:alanwells
  • 3
  • 2
5 Comments
 
LVL 10

Expert Comment

by:himanshut
ID: 35063736
why not create VIEWS for all tables that have names greater than 27 character?
and then instead of linking the tables into your CR call teh VIEWS with short names. It should get around with the issue,

Cheers!
0
 

Author Comment

by:alanwells
ID: 35063813
Thanks for the quick reply.

Excuse my ignorance but how do I do that, my Crystal Reports skills are quite limited.

0
 
LVL 10

Accepted Solution

by:
himanshut earned 500 total points
ID: 35063916
you create the VIEWS in your database

and in you CR,
choose Field Explorer --> right click on database field and choose database expert
now you'll see the pop up where you can choose the tables, double click on the view/table you want and it will be imported to right hand side of the window.

there after, you can use the fields frm the table
0
 

Author Comment

by:alanwells
ID: 35063938
Ah, unfortunately the application is proprietory, we do not have access to modify the backend :(

I will go back to the vendor to see what they can do for us, thanks.
0
 
LVL 10

Expert Comment

by:himanshut
ID: 35063986
yeah you can ask them to rename tables with some shorter names and you need to update your CR accordingly
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question