Error In Formula Crystal Report
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 site
Error Kind In Crystal Report Formula
About Us Learn more about Stack Overflow the company Business Learn more about crystal reports error in formula record_selection hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join
Formula Crystal Report If Else
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 name is not how to create formula in crystal report 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 sum formula in crystal report 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 report (header or some similar section) an
Message T_Hatim Newbie Joined: 07 Jul 2008 Location: Netherlands Online Status: Offline Posts: 1 Topic: Error
Sum Formula In Crystal Report With Groupings
in formula
How To Write Formula In Crystal Report
IP Logged rahulwalawalkar Senior Member Joined: 08 Jun 2007 Location: United Kingdom Online Status: Offline Posts: 731 Posted: 07 Jul 2008 http://stackoverflow.com/questions/2135030/this-field-name-is-not-known-error-crystal-reports at 11:30am Hi Open the report in Design Mode Go to Database menu and do verify database....the field name i.e.{CX_OUTGOING_INVOICE.LOAD_DATE} is not known means either the field is removed from the table or you are refering to wrong database wrong table..... http://www.crystalreportsbook.com/Forum/forum_posts.asp?TID=3614 cheers Rahul IP Logged Printable version Forum Jump -- Select Forum -- Announcements Talk with the Author Self-Publishing Job Postings New feature request Report Design Data Connectivity Technical Questions Tips and Tricks Crystal Xcelsius Report Design Data Connectivity Writing Code Tips and Tricks Report Design Data Connectivity Writing Code Tips and Tricks You cannot post new topics in this forumYou cannot reply to topics in this forumYou cannot delete your posts in this forumYou cannot edit your posts in this forumYou cannot create polls in this forumYou cannot vote in polls in this forum This page was generated in 0.031 seconds. HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | JAVASCRIPT FORUM © 2004-2016 Brian Bischof. All Rights Reserved.
SQL Server 2014 Express resources Windows Server 2012 resources Programs MSDN subscriptions Overview Benefits Administrators Students Microsoft Imagine https://social.msdn.microsoft.com/Forums/en-US/e8ff19e0-8c1c-40d4-a7b1-60423eec86be/crystal-reports-error-in-formula-recordselection-this-field-name-is-not-known?forum=vscrystalreports Microsoft Student Partners ISV Startups TechRewards Events Community Magazine Forums Blogs Channel 9 Documentation APIs and reference Dev centers Retired content Samples We’re sorry. The content you requested has been removed. You’ll be auto redirected in 1 second. Ask a question Quick access Forums home crystal report Browse forums users FAQ Search related threads Remove From My Forums Answered by: crystal reports: Error in formula