Crystal Report Error 20510
of2Next>> Author Message snyper19 Newbie Joined: 15 Jul 2009 Location: United States Online Status: Offline Posts: 10 Topic: error 20510 Invalid formula namePosted: 18 Feb 2010 at 8:51am Hello, I am new to CR, I need help solving an issue with this Crystal Reports... it seems to be fine but when we run the report, I get this box saying (Error Invalid Formula Name). any help I really appreciate it. below is the code in case anyone wants to see it.numberVar rs := 0;numberVar sp := 0;if (isnull({TicketProduct.SourcePercentOfRoute}) or ({TicketProduct.SourcePercentOfRoute} = 0)) thenrs := 1else rs := ({TicketProduct.SourcePercentOfRoute} * 0.01);if (isnull({TicketProduct.ProductPercentOfSource}) or ({TicketProduct.ProductPercentOfSource} = 0)) thensp := 1else := ({TicketProduct.ProductPercentOfSource} * 0.01);Round (({TicketLoad.TotalCost} * rs * sp ), 3);Thank you, IP Logged hilfy Admin Group Joined: 20 Nov 2006 Online Status: Offline Posts: 3506 Posted: 18 Feb 2010 at 9:03am Is this a typo in what you've written above or is it in your formula this way? else := ({TicketProduct.ProductPercentOfSource} * 0.01); It should be else sp := ({TicketProduct.ProductPercentOfSource} * 0.01); -Dell DecisionFirst Technologies - a Proviti Enterprise 9-Time SAP BusinessObjects Partner of the Year. www.decisionfirst.com IP Logged snyper19 Newbie Joined: 15 Jul 2009 Location: United States Online Status: Offline Posts: 10 Posted: 18 Feb 2010 at 9:19am That's how it was when I started working on this report. IP Logged snyper19 Newbie Joined: 15 Jul 2009 Location: United States Online Status: Offline Posts: 10 Posted: 18 Feb 2010 at 9:20am I don't know if it matters or not... but this report was done with CR7. and when I click if there are any errors, it doesn't show any error. IP Logged hilfy Admin Group Joined: 20 Nov 2006 Online Status: Offline Posts: 3506 Posted: 18 Feb 2010 at 9:45am You need to change it like I show above and then run it to see what happens. The formula is wrong and that's what's causing your problem. -Dell DecisionFirst Technologies - a Proviti Enterprise 9-Time SAP BusinessObjects Partner of the Year. www.decisionfirst.com IP Logged snyper19 Newbie Joined: 15 Jul 2009 Location: United States Online Status: Offline Posts: 10 Posted: 18 Feb 2010 at 9:51am oh, my bad (typo)...but yeah... the way you wrote it, its the way it is... but still it gives me the error. IP Logged hilfy Admin Group Joined: 20 Nov 2006 Online Status: Offline Posts: 3506 Posted: 18 Feb 2010 at 9:55am Try taking the final semi-colon ";" off the end. With it on there, you won't actually have a value returned. -Dell Decision
PaDocsMga contactHangoutsMas higit pa mula sa GoogleMag-sign inMga nakatagong fieldHanapin ang mga pangkat o mensahe
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive https://www.experts-exchange.com/questions/26908761/Invalid-Formula-Name.html Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > Invalid Formula Name Want to Advertise Here? Solved Invalid Formula Name Posted on 2011-03-24 crystal report Crystal Reports Programming Languages-Other Programming 2 Verified Solutions 3 Comments 1,921 Views Last Modified: 2012-05-11 Getting Error Run Time Error 20510 Invalid Formula Name formula name is TTLBAmt in crystal report CrystalReport1.Formulas(1) = "TTLBAmt = " & TTLOutStandingAmt & " 0 Question by:crystal_Tech Facebook Twitter LinkedIn Google LVL 100 Active today Best Solution bymlmcc Have you crystal report error tried CrystalReport1.Formulas(1).Text = " 'TTLBAmt = " & TTLOutStandingAmt & " ' " or CrystalReport1.Formulas(1).Text = "TTLBAmt = " & TTLOutStandingAmt & "" mlmcc Go to Solution 3 Comments LVL 1 Overall: Level 1 Programming Languages-Other 1 Message Active 5 days ago Author Comment by:crystal_Tech2011-03-24 Code i am using CrystalReport1.ReportFileName = App.Path & "\TPTLedger.rpt" CrystalReport1.Connect = con CrystalReport1.DiscardSavedData = True CrystalReport1.RetrieveDataFiles If Text1.text = "" Then CrystalReport1.SelectionFormula = "{TPT_Ledger.M_Date} >= date(" & Year(DTPickerFrom.Value) & "," & Month(DTPickerFrom.Value) & "," & Day(DTPickerFrom.Value) & ") And {TPT_Ledger.M_Date} <= date(" & Year(DTPickerTo.Value) & "," & Month(DTPickerTo.Value) & "," & Day(DTPickerTo.Value) & ")" Else CrystalReport1.SelectionFormula = "{TPT_Ledger.G_Name} = '" & Text1.text & "' and {TPT_Ledger.M_Date} >= date(" & Year(DTPickerFrom.Value) & "," & Month(DTPickerFrom.Value) & "," & Day(DTPickerFrom.Value) & ") And {TPT_Ledger.M_Date} <= date(" & Year(DTPickerTo.Value) & "," & Month(DTPickerTo.Value) & "," & Day(DTPickerTo.Value) & ")" End If CrystalReport1.Password = Chr(10) & "*******" CrystalReport1.WindowState = crptMaximized CrystalReport1.De