Solved

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

Posted on 2014-04-16
5
8,455 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to 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…
How to increase the row limit in Jasper Server.
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…

863 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now