Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
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,849 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

Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

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…
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…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…

597 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