Crystal Report Error Formula Field Name Not Known
Contents |
Tips/Tricks Top Articles Beginner Articles Technical Blogs Posting/Update Guidelines Article Help Forum Article Competition Submit an article or tip Post
Crystal Report Formula Field If Condition
your Blog quick answersQ&A Ask a Question View Unanswered Questions sum of formula field in crystal report View All Questions... C# questions Linux questions ASP.NET questions SQL questions VB.NET questions discussionsforums All Message
Formula Field In Crystal Report In C#
Boards... Application Lifecycle> Running a Business Sales / Marketing Collaboration / Beta Testing Work Issues Design and Architecture ASP.NET JavaScript C / C++ / MFC> ATL / error in formula record_selection crystal report WTL / STL Managed C++/CLI C# Free Tools Objective-C and Swift Database Hardware & Devices> System Admin Hosting and Servers Java .NET Framework Android iOS Mobile SharePoint Silverlight / WPF Visual Basic Web Development Site Bugs / Suggestions Spam and Abuse Watch features Competitions News The Insider Newsletter The Daily Build Newsletter Newsletter archive error in formula record selection this field name is not known Surveys Product Showcase Research Library CodeProject Stuff communitylounge Who's Who Most Valuable Professionals The Lounge The Insider News The Weird & The Wonderful The Soapbox Press Releases Non-English Language > General Indian Topics General Chinese Topics help What is 'CodeProject'? General FAQ Ask a Question Bugs and Suggestions Article Help Forum Site Map Advertise with us About our Advertising Employment Opportunities About Us Ask a Question All Questions All Unanswered FAQ Crystal Report - This field name is not known error. Please Help Rate this: Please Sign up or sign in to vote. See more: VB VB.NET CrystalReports Hi, I'm having a problem with my crystal report. The report displays perfectly on my computer but does not work on any other computers. When displaying the report it gives a long error message. Sadly, I can't paste the whole error message because I'm sending this message from a different computer. However. The error says that something is
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers
Crystal Report Forms Viewer The Field Name Is Not Known
or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x error in formula in crystal report Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only
This Field Name Is Not Known. Details Errorkind Error In File Temp
takes a minute: Sign up 'This field name is not known' error (Crystal Reports) up vote 5 down vote favorite Here is a strange problem I have run into. My record select formula is as follows, I have dumbed it http://www.codeproject.com/Questions/216667/Crystal-Report-This-field-name-is-not-known-error down for purposes of this error: reportDocument.RecordSelectionFormula = " {@ClientName} = 'Smith' " If I copy this exact selection statement into Crystal it previews fine, but when run from .NET I get 'This field name is not known'. The problem is occurring at the @ClientName formula field. @ClientName simply contains: formula = {aw_illust.CL1LNAM} I can also set it to just a blank string (formula = "") and it still gives 'This field name is not known.' Here is the strange http://stackoverflow.com/questions/2135030/this-field-name-is-not-known-error-crystal-reports part, if I bypass the formula and put the formula text straight into .NET everything works fine. reportDocument.RecordSelectionFormula = " {aw_illust.CL1LNAM} = 'Smith' " That is the same record selection, except with the '@ClientName' formula replaced with '{aw_illust.CL1LNAM}'. It just happens on this one report, I have many other Crystal Reports working with formulas referenced in .NET just fine. Any ideas? crystal-reports share|improve this question edited Jun 1 '15 at 5:53 shA.t 8,43141542 asked Jan 25 '10 at 19:34 user258710 You say it's working elsewhere – would you post a sample illustrating what you mean? –paulmelnikow Feb 9 '12 at 2:55 add a comment| 4 Answers 4 active oldest votes up vote 1 down vote Most likely you are not using your {@ClientName} formula anywhere on report; Crystal Reports tends to ignore unused fields, formulas etc. Place {@ClientName} field somewhere in report (header or some similar section) and suppress it - this way you don't mess up report design, but CR should know about that formula afterwards. share|improve this answer answered Aug 26 '14 at 7:37 Arvo 6,20211420 add a comment| up vote 0 down vote Which syntax has the formula? If it is crystal syntax then change it to basic syntax. Or change the content of the formula to crystal syntax (without "formula =") share|improve this answer answered Jan 27 '10 at 19:28 Horcrux7 11.7k145893 add a comment| up vote 0 down vote You could create a
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand https://www.experts-exchange.com/questions/28414009/Crystal-Reports-error-The-Field-Name-is-not-Known.html Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups http://www.crystalreportsbook.com/Forum/forum_posts.asp?TID=15517 Website Testing Store Headlines Experts Exchange > Questions > Crystal Reports error - "The Field Name is not Known" Want to Advertise Here? Solved Crystal Reports error - "The Field Name is not Known" Posted on 2014-04-16 DB Reporting Tools Crystal Reports 2 Verified Solutions 5 Comments 8,112 Views Last Modified: 2014-04-16 Hi, We are running a crystal report 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 Question by:tesla764 Facebook Twitter LinkedIn in crystal report Google LVL 22 Best Solution byplusone3055 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 Go to Solution 5 Comments LVL 22 Overall: Level 22 Crystal Reports 1 Message Accepted Solution by:plusone30552014-04-16 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 Message Author Comment by:tesla7642014-04-16 I will try that. Thanks. 0 LVL 100 Overall: Level 100 Crystal Reports 94 DB Reporting Tools 31 Message Active today Assisted Solution by:mlmcc2014-04-16 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 Message Author Comment by:tesla7642014-04-16 We are using Crystal 10. The report actually runs from VB6. 0 Message Author Closing Comment by:tesla7642014-04-16 Thanks everybody. 0 Write Comment First Name Please enter a first name Last Name Please enter a last name Email We will never share this with anyone. Comment Submit Your Comment By clicking you are agreeing to Experts Exchange's
Joined: 24 Oct 2011 Online Status: Offline Posts: 24 Topic: "This field name is not known"Posted: 02 Feb 2012 at 10:54am We're running into an issue with the Crystal Report Windows Forms Viewer in a 3rd party piece of software.When I try to run my report, it fails with the following error message:This field name is not known.Details: errorKindError in File MyReportError in formula MyFormula'{MyDataSource.MyField}This field name is not known.Details: errorKindIf I create a formula in one of my subreports that returns one of the fields, it creates this failure. Within Crystal Reports XI, I don't see this error; only in the 3rd party software.Yes, it's possible the 3rd party software might be at fault, but I'm suspecting they're not. I'm just wondering if anyone has ever experienced something like this before and can offer a possible general explanation as to where an error like this might come from? A little more information if it helps:1. I'm using a stored procedure as the data source.2. The stored procedure contains all of these fields (if it didn't, I'm sure I'dbeseeing the same failurein Crystal Reports XI, but I did check anyway).3. Originally, the report worked fine in the 3rd party software; it only started failing once I changed the data source (the original source might have had a few slight differences in terms of what fields it had, but anything being used in my report is contained in both stored procedures). both the original and the new stored procedure are the same type: ODBC (RDO). I greatly appreciate any help on this.Thank you. IP Logged CircleD Senior Member Joined: 11 Mar 2011 Location: United States Online Status: Offline Posts: 251 Posted: 03 Feb 2012 at 1:48am Have you tried remapping the Tables? IP Logged Hammerklavier Newbie Joined: 24 Oct 2011 Online Status: Offline Posts: 24 Posted: 03 Feb 2012 at 3:55am I will note that one complication with the troubleshooting process is that I'm not sure what the original stored procedure is. When I view the properties for the original stored procedure, the listed database is one that no longer exists. Yet, the report still works fine in the 3rd party software (not sure if it works in Crystal, since we don't know the credentials for this data source, w