Crystal Reports Error In Formula
Contents |
365 for Enterprise Skype for business Microsoft Dynamics Microsoft Dynamics Sales Service Marketing Social Enterprise Resource Planning Small and Midsize Business Windows Windows 10 for business Windows crystal reports error in formula record_selection this field name is not known 10 for Internet of Things Windows devices Data and analytics Data
Crystal Reports Error In Formula This Field Name Is Not Known
management and analytics Microsoft SQL Server Microsoft Power BI Microsoft Cortana Intelligence Suite Operations management Operations Management Suite
Error Kind In Crystal Report Formula
System Center Sign in Search Microsoft Search Dynamics Community Participate Ask a Question Get Started Badges Earn Badges View Badges Leaderboards Compete on Leaderboards View Leaderboards Become an
Error In Formula Section Visibility Crystal Reports
Expert Recommend a Blog Introduce Yourself Provide Feedback Communities Microsoft Dynamics AX Microsoft Dynamics CRM Microsoft Dynamics GP Microsoft Dynamics NAV Other Products Partner Community Dynamics Community Microsoft Dynamics SL Forum Blogs Videos Experts Support Dynamics Community Participate Ask a Question Get Started Badges Earn Badges View Badges Leaderboards Compete on Leaderboards View Leaderboards Become an Expert crystal reports formula syntax Recommend a Blog Introduce Yourself Provide Feedback Communities Microsoft Dynamics AX Microsoft Dynamics CRM Microsoft Dynamics GP Microsoft Dynamics NAV Other Products Partner Community Microsoft Dynamics SL Forum Blogs Videos Experts Support Crystal Report - custom report - error - field name is not known Sign In Share Twitter LinkedIn Facebook Email Print RSS Dave Simon My Badges Question Status Verified Dave Simon asked a question on 19 Nov 2012 1:28 PM 1. Just upgraded to SL2011 FP1, 2. Custom AP Edit Report (03810), 3. Print Preview results in error message: Crystal Report Windows Forms Viewer - This field name is not known. Details: errorKind Error in file 03810 {62E1DE95-319E-42E3-B58B-AC055D0D04BB}.rpt: Error in formula Record_Selection: '({vr_03810.cRI_ID}=4) AND (({jmt_vr_0310.batnbr} like '*31956*'))' This field name is not known. Details: errorKind Help!? :-) Thanks!! Dave Tags: Crystal Microsoft Dynamics SL field name is not known Reply All Responses (7) Only Answers Dave Simon My Badges Verified Answer Dave Simon responded on 21 Nov 2012 5:57 AM This was resolved by renaming the
SAP BusinessObjects BI OnDemandWhere is this place located?All Places SAP BusinessObjects BI OnDemand 4 Replies Latest reply: Nov 4, 2008 4:08 PM by Mario Quintana Tweet Error in Formula: "This field name is not known" error on CR.com Frank DeBonis Sep 11, 2008 9:20 PM Currently Being Moderated Hi. I've created crystal reports formula workshop a parameter-based report that prompts the user to enter one or more countries and a crystal reports formula variable date range. The report works fine locally in Crystal Reports XI -- it prompts the user to enter one or more countries and a crystal reports formula if date range, and then returns all the records that match those criteria. But when I upload the report to CR.com and attempt to run it, I get the following error message after entering the country and date range parameters:"Error https://community.dynamics.com/sl/f/35/t/94450 in File [report name]: Error in formula . '({@CreateDate} = {?DateRange} or ' This field name is not known. Details: errorKind"I can't find anything that explains what the errorKind msg means. Everything else seems to check out (in terms of data types matching up, etc). Any thoughts or explanations on what's going on and how to straighten it out would be very much appreciated!Frank 12400Views Re: Error in Formula: "This field name is not known" error on CR.com Mario http://scn.sap.com/thread/1042569 Quintana Sep 12, 2008 2:50 PM (in response to Frank DeBonis) Currently Being Moderated Hi Frank,In reviewing the error message, I would check the following:1. Confirm that all data source objects are correctly mapped and verified within Crystal Reports. It is possible that a database field within one of the tables has changed or been modified on the DB side of the house. If a report was to refresh against the existing structure and not find the object (name mismatch or object has been deleted) you would see a similar error message. 2. From the initial syntax you have two objects; one object is a formula and the other a parameter. The formula object concerns me more because there could have been modification made within the formula syntax due to database changes or there are table objects referenced that no longer exist or the formula references other formulas which may be incorrect or there are misspelled or incorrect syntax within the formula which is failing to compile during the formula check but it is failing to compile when the report is run in CRDC and not the report designer.3. If the formula is failing to compile correctly, then this would leave me to review my patch version of Crystal Reports (the report designer). For CR XI / CR XI R1, this product no longer has any patch support which means that the latest and
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 http://thedatafarm.com/tools/crystal-reports-error-in-formula-record_selection/ again).I used one cyrstal report as a basis for another. So I literally copied the report files to a new folder.When running the report an error was thrown that I could not debug:Error in File C:\DOCUME~1\Julie\LOCALS~1\Temp\temp_8c3aef3e-caf3-4214-99ee-6ff344a4c8a7.rpt:Error in formula