Home > Crystal Report > Crystal Report Error Boolean Is Required Here

Crystal Report Error Boolean Is Required Here


Connect The Blackbaud team is online and ready to connect with you! This is very bizarre! Thanks for your response! -Carol Quote: >Carol, I can't explain why you are getting different behavior in the two >reports. Things Ive tried that ive seen answers for online that hasn't worked: 1) Checked the return type of the dataset incase there was a discrepancy 2) Used both switch and regular http://swirlvision.com/crystal-report/crystal-report-error-a-number-is-required-here.html

The original report I need a '1' or '0' and the copied report I need a 'True' or 'False' !!!!! Thank you! All rights reserved.Unauthorized reproduction or linking forbidden without expressed written permission. so when I tried Cbool() I got an error that a number is required, I ended up casting it as a double then casting that as a boolean and that workd. hop over to this website

A Boolean Array Is Required Here Crystal Reports

First Name Please enter a first name Last Name Please enter a last name Email We will never share this with anyone. Details: errorKind Error in File CPTCharges {FD775771-FD54-40B1-891A-87AFD9539789}.rpt: Error in formula CPTCodes: 'if {CPTCodes.Day} = "0" Then ' A boolean is required here. Connect with top rated Experts 15 Experts available now in Live! Does the server have Crystal installed on just the runtime?

Join and Comment By clicking you are agreeing to Experts Exchange's Terms of Use. Characters Remaining: 255 Blackbaud Community Connect and collaborate with fellow Blackbaud users. not quite as a number and not quite as a boolean. Get 1:1 Help Now Advertise Here Enjoyed your answer?

asked 3 years ago viewed 5616 times active 3 years ago Upcoming Events 2016 Community Moderator Election ends in 3 days Get the weekly newsletter! Crystal Boolean Formula there is something funny the way the production server is seeing the data. I am using the same database, the same tables and the same fields...the same 'copied' report. More Bonuses Here's Why Members Love Tek-Tips Forums: Talk To Other Members Notification Of Responses To Questions Favorite Forums One Click Access Keyword Search Of All Posts, And More...

Is the Joker based on anything? It does this via a c… Document Imaging Document Management Adobe Acrobat Images and Photos Photos / Graphics Software Rename and move Database and log to new volume in Exchange 2013/2016 Posting Guidelines Promoting, selling, recruiting, coursework and thesis posting is forbidden.Tek-Tips Posting Policies Jobs Jobs from Indeed What: Where: jobs by Link To This Forum! Originally I tried doing a simple switch, but since that wasnt working I tried nested if statements.

Crystal Boolean Formula

Join the community of 500,000 technology professionals and ask your questions. Get 1:1 Help Now Advertise Here Enjoyed your answer? A Boolean Array Is Required Here Crystal Reports if expr_1 then (do_1; do_2) else (do_3; if expr_2 then (do_4; do_5) else (do_6; do_7) ) You could also try: if {CPTCodes.Day} = "0" AND {CPTCodes.D0} = "1" Then {CPTCodes.CPTID} else Crystal Report If Then Else Ill report back on the code change. –Kevin Fauver Nov 14 '13 at 0:37 Edited main post with the snippet I tried.

My point is if the upper part is True/False, the lower part can't be a string. 0 LVL 1 Overall: Level 1 Message Author Comment by:Gerhardpet2010-10-14 Comment Utility Permalink(# a33905742) his comment is here Suggested Solutions Title # Comments Views Activity Explain Unit of Work pattern 2 39 45d javascript call 6 32 19d (code works) but print excel in Landscape 5 43 22d Align Login. I upped yours though because you got it right in one of your comments. –Kevin Fauver Nov 20 '13 at 19:21 | show 1 more comment up vote 2 down vote What Is A Boolean

I've attache a screen shot. 5-31-2012-7-55-40-PM.png 0 Message Author Comment by:jfb11262012-05-31 Comment Utility Permalink(# a38035109) Tried changing to crystal syntax with basically the same results... if (isnull({Table1.Taxable}) or {Table1.Taxable}=0) then Change the "or" at the end of the first line to "else" 0 LVL 1 Overall: Level 1 Message Author Comment by:Gerhardpet2010-10-14 Comment Utility Permalink(# a33905860) that was easy...Thank you! Join and Comment By clicking you are agreeing to Experts Exchange's Terms of Use. this contact form That doesn't seem to be working.

It makes no sense. Covered by US Patent. Resources Join | Indeed Jobs | Advertise Copyright © 1998-2016 ENGINEERING.com, Inc.

Details: errorKind 0 Comment Question by:jfb1126 Facebook Twitter LinkedIn Email https://www.experts-exchange.com/questions/27739764/Crystal-Report-error-A-boolean-is-required-here.htmlcopy Best Solution byjfb1126 I finally got it!!!!!

Error: object required: 'WScript' 11. Are you using the same database type (Oracle, SQL Server, etc) and the same database drivers for the report? Privacy Policy Site Map Support Terms of Use MenuExperts Exchange Browse BackBrowse Topics Open Questions Open Projects Solutions Members Articles Videos Courses Contribute Products BackProducts Gigs Live Courses Vendor Services Groups Head, Shoulders, Knees and Toes, Knees and Toes What is the point of heating the IAC Valve?

Close Reply To This Thread Posting in the Tek-Tips forums is a member-only feature. Covered by US Patent. the error text : A boolean is required here. http://swirlvision.com/crystal-report/crystal-report-error-string-is-required-here.html Chat with Support Chat with our experienced staff to receive help right away.

both are MySQL 5.1 the field is a tinyint (1). Why can't > >you just use the True/False constants? > >-- > >Paul Little, Senior Programmer/Analyst > >SVi Retail Systems > >San Diego, CA > >> This has stumped me.... > Should I have doubts if the organizers of a workshop ask me to sign a behavior agreement upfront? "You hear but you don't listen" or "You listen but you don't hear"? Close this window and log in.

I've deleted the field and recreated it with a different name, nothing... 0 LVL 100 Overall: Level 100 Crystal Reports 94 ASP.NET 18 Message Active today Expert Comment by:mlmcc2012-05-31 Comment Crystal Reports uses a two-pass reporting process to provide greater … Crystal Reports How to Monitor Bandwidth using SNMP or WMI using PRTG Network Monitor Video by: Kimberley This video gives