Error In Formula In Crystal Report
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have crystal reports error in formula record_selection Meta Discuss the workings and policies of this site About Us Learn rpt error in formula more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us formula crystal report if else Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like how to create formula in crystal report you, helping each other. Join them; it only 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 down for purposes of this error: reportDocument.RecordSelectionFormula =
Sum Formula In Crystal Report
" {@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 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
SQL Server 2014 Express resources Windows Server 2012 resources Programs MSDN subscriptions Overview Benefits Administrators
Sum Formula In Crystal Report With Groupings
Students Microsoft Imagine Microsoft Student Partners ISV Startups TechRewards suppress formula in crystal report Events Community Magazine Forums Blogs Channel 9 Documentation APIs and reference Dev centers how to write formula in crystal report Retired content Samples We’re sorry. The content you requested has been removed. You’ll be auto redirected in 1 second. Ask a http://stackoverflow.com/questions/2135030/this-field-name-is-not-known-error-crystal-reports question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Answered by: crystal reports: Error in formula
Message T_Hatim Newbie Joined: 07 Jul 2008 Location: Netherlands Online Status: Offline Posts: 1 Topic: Error http://www.crystalreportsbook.com/Forum/forum_posts.asp?TID=3614 in formula
sphere login blackbaud labs noza blackbaud tv netwits thinktank usa uk pacific netherlands canada Error: The field name is not known when running a Crystal report Error: "The field name is not known" This error may occur within a Crystal report formula if the field has been removed from the export or if there is a typo in the field name. Article Number:44537 Products: Crystal_Reports Check the formula to make sure the correct field is being used. If it is, check to make sure the field is included in the export. If the field is missing from the export, add the field to the export output. Check the formula to make sure there is only one set of curly brackets around the field name, for example, {CnBio_SortKey} Was this article helpful? Feedback Please tell us how we can make this article more useful. Characters Remaining: 255 Blackbaud Community Connect and collaborate with fellow Blackbaud users. Chat with Support Chat with our experienced staff to receive help right away. Connect The Blackbaud team is online and ready to connect with you! Privacy Policy Safe Harbor Terms of Use Acceptable Use Policy