Error In Formula The Field Name Is Not Known
Contents |
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 crystal reports error in formula this field name is not known site About Us Learn more about Stack Overflow the company Business Learn more
Error In Formula Record Selection This Field Name Is Not Known
about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x crystal report forms viewer the field name is not known 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 takes a minute: Sign up 'This field
Error In Formula In Crystal Report
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 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. details errorkind error in file temp '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 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,46641542 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
Tips/Tricks Top Articles Beginner Articles Technical Blogs Posting/Update Guidelines Article Help Forum Article Competition Submit an article or tip Post your Blog quick answersQ&A Ask a Question
This Field Name Is Not Known. Details Errorkind Error In File Rpt
View Unanswered Questions View All Questions... C# questions Linux questions ASP.NET questions
Error In Formula Section Visibility Crystal Reports
SQL questions VB.NET questions discussionsforums All Message Boards... Application Lifecycle> Running a Business Sales / Marketing Collaboration / crystal report show sql query this field name is not known Beta Testing Work Issues Design and Architecture ASP.NET JavaScript C / C++ / MFC> ATL / WTL / STL Managed C++/CLI C# Free Tools Objective-C and Swift Database Hardware & http://stackoverflow.com/questions/2135030/this-field-name-is-not-known-error-crystal-reports 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 Surveys Product Showcase Research Library CodeProject Stuff communitylounge Who's Who Most Valuable Professionals The Lounge The Insider News The Weird http://www.codeproject.com/Questions/216667/Crystal-Report-This-field-name-is-not-known-error & 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 wrong in one of my formula fields and also the field name is not known. But it works fine in my computer. Also, the error says something about a temporary report file as well. Posted 26-Jun-11 16:09pm obhasha07501 Add a Solution 4 s
Tips/Tricks Top Articles Beginner Articles Technical Blogs Posting/Update Guidelines Article Help Forum Article Competition Submit an article or tip Post your http://www.codeproject.com/Questions/444238/This-field-name-is-not-known-error-showing Blog quick answersQ&A Ask a Question View Unanswered Questions View All Questions... C# questions Linux questions ASP.NET questions SQL questions VB.NET questions discussionsforums All Message Boards... Application Lifecycle> Running a Business Sales / Marketing Collaboration / Beta Testing Work Issues Design and Architecture ASP.NET JavaScript C / C++ / MFC> ATL / WTL / STL Managed error in 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 Surveys Product Showcase Research Library field name is 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 "This field name is not known" error showing Rate this: Please Sign up or sign in to vote. See more: CrystalReports "This field name is not known" error showing in a formula field while viewing the report through the crystal report viewer. It works while running in the crystal designer window. Only difference while running from vb.net application it uses a temperory table that links with other tables in the report. The formula causing error is not a field from the temperory table. Anybody has any ideas?. I use sql server 2008 as the database Posted 21-Aug