Error In Formula Crystal Reports
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
Crystal Reports Error In Formula Record_selection
Stack Overflow the company Business Learn more about hiring developers or posting ads with error kind in crystal report formula us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is
Error In Formula Section Visibility Crystal Reports
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 known' error (Crystal Reports) up vote 5 down vote formula crystal reports examples 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'. The problem is occurring at the @ClientName formula field. @ClientName simply selection formula in crystal reports 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) 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
and SafetyAsset NetworkAsset
Count Formula In Crystal Reports
Operations and MaintenanceCommerceOverviewSubscription Billing and Revenue ManagementMaster sum formula in crystal reports Data Management for CommerceOmnichannel CommerceFinanceOverviewAccounting and Financial CloseCollaborative Finance OperationsEnterprise
Average Formula In Crystal Reports
Risk and ComplianceFinancial Planning and AnalysisTreasury and Financial Risk ManagementHuman ResourcesOverviewCore Human Resources and PayrollHuman Capital http://stackoverflow.com/questions/2135030/this-field-name-is-not-known-error-crystal-reports AnalyticsTalent ManagementTime and Attendance ManagementManufacturingOverviewManufacturing NetworkManufacturing OperationsResponsive ManufacturingMarketingOverviewMarket with Speed and AgilityUnique Customer ExperiencesReal-Time Customer InsightsR&D/EngineeringOverviewDesign NetworkDesign OrchestrationProject and Portfolio ManagementSalesOverviewCollaborative Quote to CashSales Force AutomationSales Performance ManagementSelling Through Contact CentersServiceOverviewEfficient Field Service ManagementOmnichannel https://scn.sap.com/thread/3177928 Customer ServiceTransparent Service Process and OperationsSourcing and ProcurementOverviewContingent Workforce ManagementDirect ProcurementSelf-Service ProcurementServices ProcurementStrategic Sourcing and Supplier ManagementSupply ChainOverviewDemand ManagementDemand NetworkLogistics NetworkManufacturing Planning and SchedulingResponse NetworkResponse and Supply ManagementSales, Inventory, and Operations PlanningTransportation ManagementWarehouse ManagementSustainabilityOverviewEnvironment, Health, and SafetyProduct Safety and Stewardship NetworkBrowse by IndustryAerospace and DefenseAutomotiveBankingChemicalsConsumer ProductsDefense and SecurityEngineering, Construction, and OperationsHealthcareHigh TechHigher Education and ResearchIndustrial Machinery and ComponentsInsuranceLife SciencesMediaMill ProductsMiningOil and GasProfessional ServicesPublic SectorRetailSports and EntertainmentTelecommunicationsTravel and TransportationUtilitiesWholesale DistributionBrowse Platform and TechnologyAnalyticsOverviewBusiness IntelligencePredictive AnalyticsGovernance, Risk, and ComplianceEnterprise Performance ManagementApplication Platform and InfrastructureOverviewApplication PlatformContent and CollaborationInterface ManagementProcess Management and IntegrationData ManagementOverviewBig Data on HadoopData WarehousingDatabase ManagementEnterprise Information ManagementIT ManagementOverviewApplicatio
SQL Server 2014 Express resources Windows Server 2012 resources Programs MSDN subscriptions Overview Benefits Administrators Students Microsoft Imagine Microsoft Student 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 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 Browse forums users FAQ crystal report Search related threads Remove From My Forums Answered by: crystal reports: Error in formula