Solved

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

Posted on 2011-03-07
5
2,723 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say 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

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
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…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …

726 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