?
Solved

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

Posted on 2011-03-07
5
Medium Priority
?
2,798 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 2000 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

New benefit for Premium Members - Upgrade now!

Ready to get started with anonymous questions today? It's easy! Learn more.

Question has a verified solution.

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

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
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 …
Suggested Courses

762 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