Solved

Crystal Reports error - "The Field Name is not Known"

Posted on 2014-04-16
5
8,694 Views
Last Modified: 2014-04-16
Hi,
  We are running a new Crystal Report named Destruction History. The system prompts the user for Item Code, Lot Number, and Expiration Date. After running for about 3- seconds to a minute, the system responds with error "The field name is not known".
Any ideas on what may be causing this? We have verified through SQL that the data exists. Any help or similar experience would be greatly appreciated.
Thanks in advance.
0
Comment
Question by:tesla764
  • 3
5 Comments
 
LVL 22

Accepted Solution

by:
plusone3055 earned 450 total points
ID: 40004360
Usually when this is happening the locatio nof hte database has changed or possibly the name of the database has changed. I would open up the databsae expert and re-create the database connection.. That should clear it up :)
0
 

Author Comment

by:tesla764
ID: 40004397
I will try that. Thanks.
0
 
LVL 100

Assisted Solution

by:mlmcc
mlmcc earned 50 total points
ID: 40004473
What version of Crystal?

You should be able to simply do a VERIFY DATABASE in the report designer.

Does the report run from the Crystal designer?

mlmcc
0
 

Author Comment

by:tesla764
ID: 40004572
We are using Crystal 10.  The report actually runs from VB6.
0
 

Author Closing Comment

by:tesla764
ID: 40004679
Thanks everybody.
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

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

Title # Comments Views Activity
SCCM Microsoft Report 2 79
Date is within the current week in Crystal Reports 2 76
Crystal report highlighting 5 44
Legend Colours Not Matching Riser Colours 9 15
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. …
I recently went through setting up a JasperReports Server using the AWS EC2 instance, and this article will cover some basic administration tasks I had to perform.
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

791 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