Error In Formula Record_selection 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 About Us Learn more about Stack Overflow the company Business Learn more about hiring error in formula record selection crystal reports developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question error kind in crystal report formula x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; exception in formula @record_selection 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
Crystal Report Field Name Is Not Known
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'. 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.' record selection formula in crystal report in c# 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) 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,21211420 add a comment| Did you find this question interesting? Try our newsletter Sign up for our newsletter and get our top new questions delivered to your inbox (see an example). Subscribed! Success! Please click the link in the confirmation email to activate your subscription. up vote 0 down vote Which syntax h
was a REALLY difficult problem to track down so I am adding it into the world for google to help someone else (or even myself again).I used one cyrstal report as a basis for another. So I literally copied the report files crystal report record selection formula example to a new folder.When running the report an error was thrown that I could not
How To Use Record Selection Formula In Crystal Report
debug:Error in File C:\DOCUME~1\Julie\LOCALS~1\Temp\temp_8c3aef3e-caf3-4214-99ee-6ff344a4c8a7.rpt:Error in formula
Crystal Reports Record Selection Formula Like
the namespace MDTTests is from the original report. So I knew that it was left over somewhere in this report. It took me over an hour to find it. Now it seems obvious and easy to find, I http://stackoverflow.com/questions/2135030/this-field-name-is-not-known-error-crystal-reports don't know what took me so long to try thisOnce in here, I could see the offending code that just needed to be deleted. This is related to linking a sub report but does not show up in the dialog for linking a sub report and it does not get cleared on it's own for some reason. In fact you can see that each time I went to fiddle with this setting through the link http://thedatafarm.com/tools/crystal-reports-error-in-formula-record_selection/ sub-report dialog, it just kept adding to the list.I removed all but the last of these lines and my report came up perfectly.
Post navigation ← still an mvp how a developer saves two minutes of their precious time → 10 thoughts on “Crystal Reports Error in Formula Record_Selection” K. Salem says: September 21, 2008 at 7:14 am I'm running through the same problem here, only it is not related to a subreport or anything, it's just a normal report, when I open it in the report preview tool within visual studio, it runs perfectly, but during runtime, the error is issued. Any ideas? Reply Julia Lerman says: September 21, 2008 at 11:29 am Oh, I wouldn't know even where to begin. Sorry. Have you tried the Crystal reports forums? If you can't find a scenario that matches yours, add a new question. Feel free to come back here and add a link to the thread so anyone else who finds this blog post can get some additional info. Here's the forum link. forums.sdn.sap.com/…/forum.jspa the prompt for a certificate.julie Reply nick says: November 6, 2008 at 10:02 pm this is crazy problem !! thanks a lot for your very helpful info !!! Reply Rajesh Chandra says: September 6, 2009 at 11:51 pm Thanks for the pointers. Though my architecture is different, youMessage 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