Crystal Report Error A Number Is Required Here
Contents |
SAP Crystal ReportsWhere is this place located?All Places SAP Crystal Reports 11 Replies Latest reply: Oct 3, 2008 10:21 PM by Sastry Duvvuri Tweet Formula - A number is required here Darla Evers Oct 3, 2008 5:43 PM Currently Being Moderated I
A Boolean Is Required Here Crystal Report Error
am a novice with Crystal Reports. I have entered the formula below.if {InsLine.LineAnnualizedPrem} >= a string is required here error in crystal report '0' then Maximum ({InsCovTerm.CovTermVersion}) else 0I am receiving an error when I test the formula. The error is "A number is
A Number Or Currency Amount Is Required Here Crystal Report
required here' and the '0' is highlighted. The field is a numeric field (verified in browse field). What is causing this to error. I have the LineAnnualizedPrem as the 3rd sort in the report and a datetime is required here in crystal report it is ouput on the report. Any ideas on why it is requesting the number? Thank you. 5725Views Re: Formula - A number is required here Graham Cunningham Oct 3, 2008 6:02 PM (in response to Darla Evers) Currently Being Moderated Darla,Right click on Database Fields in the Field Explorer and check show field type. Then check that the field {InsCovTerm.CovTermVersion} is in fact a number. If it isn't you will crystal report error 20525 need to use the tonumber function to convert it. Alert Moderator Like (0) Re: Formula - A number is required here Darla Evers Oct 3, 2008 6:17 PM (in response to Graham Cunningham) Currently Being Moderated Both of the fields are numeric. Alert Moderator Like (0) Re: Formula - A number is required here Sastry Duvvuri Oct 3, 2008 6:54 PM (in response to Darla Evers) Currently Being Moderated Hi..Please use this if {InsLine.LineAnnualizedPrem} >= 0 then Maximum({InsCovTerm.CovTermVersion}) else 0Regards,Sastry Alert Moderator Like (0) Re: Formula - A number is required here Darla Evers Oct 3, 2008 7:11 PM (in response to Sastry Duvvuri) Currently Being Moderated Sastry -I tried what you requested and I am now receiving and error "A boolean is required here.'. It highlights the entire If and Else statement.if {InsLine.LineAnnualizedPrem} >= 0 then Maximum({InsCovTerm.CovTermVersion}) else 0 Alert Moderator Like (0) Re: Formula - A number is required here Sastry Duvvuri Oct 3, 2008 7:27 PM (in response to Darla Evers) Currently Being Moderated Hi Darla,Please try this :Numbervar x;if not isnull({InsLine.LineAnnualizedPrem}) and {InsLine.LineAnnualizedPrem} >= 0 then x:=tonumber(Maximum({InsCovTerm.CovTermVersion})) else x:=0 Thanks,Sastry Alert Moderator Like (0) Re: Formula - A number is required here Darla Evers Oct 3, 2008 7:40 PM (in response to Sastry Duvvuri) Curr
sallyjenkins Newbie Joined: 24 Jun 2014 Location: United States Online Status: Offline Posts: 6 Topic: A Number is required here - error messagePosted: 07 Jul 2014 at 11:14am I am using Crystal Reports 11.5 and Crystal Reports syntax. I am reading from a SQL DB Here
Crystal Report Error Codes
are the SQL Field types. {AckParagraphs.AckParagraphBlurb} is a VarChar(Max) {AckParagraphs.AckParagraphNum} is a nchar(5) ParaNum crystal report error database vendor code 3621 is a Global NumberVar set to 999 in the group header. The purpose of this formula is to print each detail line until
Crystal Report Error The String Is Non Numeric
a blank field is reached. When the record with the blank field is read I want the variable set to the paragraph number. This variable will be used in other formulas when printing records. This formula is throwing and error https://scn.sap.com/thread/1073549 on the 2nd 'If' "A number is required here. If isNull({AckParagraphs.AckParagraphBlurb}) THEN ParaNum := ToNumber({AckParagraphs.AckParagraphNum}) Else If ParaNum = 999 THEN {AckParagraphs.AckParagraphBlurb}I'm at a total loss. SAJ IP Logged DBlank Senior Member Joined: 19 Dec 2008 Online Status: Offline Posts: 8522 Posted: 07 Jul 2014 at 12:04pm all possible results from a formula must return the sama data type You don't have to display your formula field to use it in another formula IP Logged sallyjenkins Newbie http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=20867 Joined: 24 Jun 2014 Location: United States Online Status: Offline Posts: 6 Posted: 07 Jul 2014 at 12:12pm If I understand correctly, this is blowing up because I am displaying the {AckParagraphs.AckParagraphBlurb} - correct?If that is so, then perhaps I should not set ParaNum to a Numbervar. The ParaNum is then set to {AckParagraphs.AckParagraphNum} (a string value, not changed to a number value).am I getting warm? SAJ IP Logged DBlank Senior Member Joined: 19 Dec 2008 Online Status: Offline Posts: 8522 Posted: 08 Jul 2014 at 3:52am yes. they both need to be a string or numeric and clearly the numeric won't work for the blurb. However, not knowing what your end game is here i cant really tell you how I would approach it. This will give you the paragraph number for anything where the the blurb is null and a 999 for the non NULL rows... if isNull({AckParagraphs.AckParagraphBlurb}) THEN 999 ELSE ToNumber({AckParagraphs.AckParagraphNum}) However, I am concerned that you are trying to do some sort of linking on the reult of this formula. All your row level data has already been set via the table links by the time this formula is executed.Edited by DBlank - 08 Jul 2014 at 3:53am IP Logged sallyjenkins Newbie Joined: 24 Jun 2014 Location: United States Online Status: Offline Posts: 6 Posted: 08 Jul 2014 at 4:35am Many thanks for elaborating. I am not goi
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 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 https://www.experts-exchange.com/questions/24301942/Crystal-Reports-Formula-Error-'A-Number-is-Required-Here'.html BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > https://community.spiceworks.com/topic/156095-number-is-required-here Crystal Reports Formula Error 'A Number is Required Here' Want to Advertise Here? Solved Crystal Reports Formula Error 'A Number is Required Here' Posted on 2009-04-07 Crystal Reports 1 Verified Solution 3 Comments 2,806 Views Last Modified: 2012-05-06 Hi, I'm trying to construct a very simple formula in Crystal Reports that will only display the value if it is greater than zero. This is crystal report the formula I have: - If {Client.Units} <> 0 then {Clients.Units} else "" I get 'A number is required here' error. Have tried this too: - If {Clients.Units} = 0 then "" else {Clients.Units} For this I get a 'String is Required Here' error! I'm sure this is very simple to resolve but I'm relatively new to Crystal and any help would be greatly appreciated. Thanks in advance. 0 Question by:bdoshuk Facebook Twitter LinkedIn Google LVL 77 Best Solution bypeter57r The crystal report error outputs from an if..then..else.. must be the same datatype - all strings, all numbers, all dates or whatever. In this case you do not need a formula field at all. You right-click the Units field Go to Solution 3 Comments LVL 77 Overall: Level 77 Crystal Reports 34 Message Accepted Solution by:peter57r2009-04-07 The outputs from an if..then..else.. must be the same datatype - all strings, all numbers, all dates or whatever. In this case you do not need a formula field at all. You right-click the Units field and choose Format Field. You can then check the Suppress when zero option which you will find on the Customize button of the Number tab. 0 LVL 10 Overall: Level 10 Crystal Reports 9 Message Expert Comment by:dougvarga2009-04-07 Becuase {Clients.Units} is a number, the "else" clause must also return a number. If you are trying to suppress this field if zero, you should use a number format instead. Place the {Clients.Units} on the report, right click and select Format Field Click on the number tab and then customize button. put a Check in suppress if zero. 0 Message Author Closing Comment by:bdoshuk2009-04-07 Many thanks! 0 Write Comment First Name Please enter a first name Last Name Please enter a last name Email We will never share this with anyone. Comment Submit Your Comment By clicking you are agreeing to Experts Exchange's Terms of Use. Featured Post What Is Threat Intell
in charge of leading our team through the full project, from planning to completion. Server Virtualization In the wake of a primary server failure I implemented a stop-gap fix using virtualization, proposed new hardware that exceeded foreseeable performance needs, and migrated 5 physical servers unto a Cisco hypervisor using VMware vSphere OCR Prototype - anesthesiology Develop OCR prototype for Anesthesiology data capture and analysis. IN THIS DISCUSSION Join the Community! Creating your account only takes a few minutes. Join Now I have a report that is working correctly but I would like to have a grand total of a calculated field. I have a database field called hours and a database fields called rate then I calculate the the cost of the labor by hours * rate = cost now I would like to have a total of cost but when I use the formula: whileprintingrecords; shared numbervar CostSum; CostSum := CostSum + {@Cost} When I do the check I get the error : A number is required here. I am using Crystal 8.5 Thank you for any help. whileprintingrecords; ed numbervar CostSum; CostSum:= CostSum + {@Cost} whileprintingrecords; shared numbervar CostSum; CostSum:= CostSum + {@Cost} whileprintingrecords; shared numbervar CostSum; CostSum:= CostSum + {@Cost} Reply Subscribe View Best Answer RELATED TOPICS: Show the labor rate on report   3 Replies Pimiento OP Best Answer rp810 Sep 14, 2011 at 3:51 UTC Got it figured out thank you. 0 Pimiento OP jgminkc Mar 23, 2012 at 8:12 UTC 1st Post Can you elaborate on the fix to this problem? Shared NumberVar MyVar; whileprintingrecords; MyVar:=MyVar + {@TSubTot}; 0 Jalapeno OP amenconi Mar 23, 2012 at 11:42 UTC jg, I assume when you go to save the above formula it gives you "number is required here" error and then it highlights the {@TsubTot} field? If so is there any reason to suspect that the formula doesn't return a number? If it doesn't the problem is that you are trying to add a number with a non-number data type which can't be done. Also I've always seen whileprintingrecords; at the top of the formula but it most likely mak