Crystal Report Error A String Is Required Here
Contents |
Tran Newbie Joined: 24 Oct 2011 Online Status: Offline Posts: 11 Topic: "A string is required here" error message...Posted: 25 Jun 2012 at 5:35am Hello, Iam rebuilding a report that was originally created out of the Business View a string is required here in crystal report formula data sourceand creating a new report out of theODBC data source connection.There is a
Crystal Reports A String Is Required Here Date
formula that works in the Business View but when I create the same formula in ODBC I get the "A string is crystal report error the string is non numeric required here" error. The formula is: DTSToDate ({Incdnt.AffctdPersnDOB}). I have the same exact number of tables and correct joins but don't know why I get the error message. I really appreciate any guidances.Thank you, Thanh
A Boolean Is Required Here Crystal Report Error
IP Logged kevlray Senior Member Joined: 29 Oct 2009 Location: United States Online Status: Offline Posts: 1175 Posted: 25 Jun 2012 at 6:43am Is your field {Incdnt.AffctdPersnDOB} a string. If not you will need to convert it to a string for the DTSToDate function. IP Logged TC Tran Newbie Joined: 24 Oct 2011 Online Status: Offline Posts: 11 Posted: 25 Jun 2012 at 7:17am Hi Kevlray, Thank you so much crystal report error 20525 for responding to my post! Oh, it's a DateTime. The otehr version was converted to a String. How do you convert a dateTime to a String format? I really appreciate your help!!! Thanh IP Logged kevlray Senior Member Joined: 29 Oct 2009 Location: United States Online Status: Offline Posts: 1175 Posted: 25 Jun 2012 at 12:46pm I think we to step back and see what you are trying to accomplish. The DTSToDate takes a Date Time String and converts it to a date. Since you have a Date Time value, if you just want the date, then use Date({Incdnt.AffctdPersnDOB}. If you need a string from the Date Time, then you can use the Cstr function (look at the help for the options). IP Logged TC Tran Newbie Joined: 24 Oct 2011 Online Status: Offline Posts: 11 Posted: 28 Jun 2012 at 10:36am Kevlray, Thanks again for the reponse! I replaced the DTSToDate function with he Date function and it worked! Thank you! I'm not exactly sure why my formerco-worker converted thefield type from DateTime to String. I'm curious how he was able to convert the field type from the table from DateTime to String. I appreciate you for helping me with this issue! Have a great day! Thanh IP Logged Printab
Analytics Conference: Oct 18, Mastering SAP BI, Melbourne: Oct 23. A string is required here Search this topic...|Search Crystal Reports...|Search Box Select a search Explain These Choices... --------------------Recent Topics (All Forums) Unanswered Posts
Crystal Report Error Codes
Register or Login to Post Forum Index -> Building Reports -> Crystal Reports
Crystal Report Error Database Vendor Code 3621
Author Message dellsterPrincipal MemberJoined: 14 Oct 2008Posts: 228 Posted: Fri Jul 09, 2010 3:44 pmPost subject: A string is required here I'm crystal report error 91 getting "a string is required here" when in the formula, I put: if {Command.1} = 0 then 'Error' else Previous({Command.1}) / {Command.1} Please help. Back to top Sanjay KodidineSenior MemberJoined: 19 Mar 2008Posts: 54Location: Anchorage, AK http://www.crystalreportsbook.com/Forum/forum_posts.asp?TID=16845 Posted: Fri Jul 09, 2010 4:02 pmPost subject: Re: A string is required here The result of an IF statement and the ELSE should be of the same data type. In your IF statement, the result is 'Error' or string whereas the ELSE part results in a number. Change one or the other such that the result of both IF and ELSE are the same data type. Back to top dellsterPrincipal MemberJoined: http://www.forumtopics.com/busobj/viewtopic.php?p=738951 14 Oct 2008Posts: 228 Posted: Fri Jul 09, 2010 4:11 pmPost subject: Re: A string is required here Is there a function to convert numeric to character? Back to top JBrayPrincipal MemberJoined: 15 Jul 2008Posts: 364Location: Phoenix Posted: Fri Jul 09, 2010 6:29 pmPost subject: Re: A string is required here ToText()_________________Senior Technical Consultant InfoSol, Inc. http://www.infosol.com Back to top MJRBIMForum EnthusiastJoined: 23 Mar 2007Posts: 1117Location: Toronto, Canada Posted: Mon Jul 12, 2010 12:49 pmPost subject: Re: A string is required here JBray wrote: ToText() ...but you will need to do a REPLACE to the resulting STRING (eg. "2,986.00") to get rid of the ".00" and any thousands-separators._________________Senior Business Intelligence Consultant Toronto, Canada http://www.roserichardsonenterprises.com SeagateInfo 7 -> Crystal Enterprise -> BOE-XI (R2) / (R3.1) / 4.1 | Crystal ( 7 -> 2013) design | WebI design | Best practices for Java / .Net / Web Services Back to top JBrayPrincipal MemberJoined: 15 Jul 2008Posts: 364Location: Phoenix Posted: Mon Jul 12, 2010 3:15 pmPost subject: Re: A string is required here Actually, you can just include a format overload to handle the decimals as in: Code: ToText({number}, "0") _________________Senior Technical Consultant InfoSol, Inc. http://www.infosol.com Back to top Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 YearOldest FirstNewest First Register or Login to P
Tips/Tricks Top Articles Beginner Articles Technical Blogs Posting/Update Guidelines Article Help Forum Article Competition Submit an article http://www.codeproject.com/Questions/596370/AddplusHyperlinkpluswithplusquerystringplusinplusc or tip Post your Blog quick answersQ&A Ask a Question https://bytes.com/topic/visual-basic/answers/764097-crystal-reports-error-string-required-here View Unanswered Questions View All Questions... C# questions Linux questions ASP.NET questions SQL questions VB.NET questions discussionsforums All Message Boards... Application Lifecycle> Running a Business Sales / Marketing Collaboration / Beta Testing Work Issues Design and Architecture ASP.NET JavaScript C crystal report / C++ / MFC> ATL / WTL / STL Managed C++/CLI C# Free Tools Objective-C and Swift Database Hardware & Devices> System Admin Hosting and Servers Java .NET Framework Android iOS Mobile SharePoint Silverlight / WPF Visual Basic Web Development Site Bugs / Suggestions Spam and Abuse Watch features Competitions News crystal report error The Insider Newsletter The Daily Build Newsletter Newsletter archive Surveys Product Showcase Research Library CodeProject Stuff communitylounge Who's Who Most Valuable Professionals The Lounge  The Insider News The Weird & The Wonderful The Soapbox Press Releases Non-English Language > General Indian Topics General Chinese Topics help What is 'CodeProject'? General FAQ Ask a Question Bugs and Suggestions Article Help Forum Site Map Advertise with us About our Advertising Employment Opportunities About Us Ask a Question All Questions All Unanswered FAQ crystal report : formula error - A string is required here Rate this: Please Sign up or sign in to vote. See more: ASP.NET CrystalReports Hi all, I want to create crystal report using below formula- "Lightbox_Org_Course_User_Details.aspx?reqIndDivID=" + ToNumber ({dt_Org_Ind.ind_div_id}) + "&reqLevel=" + {?reqLevel} + "&reqDivision=" + {?reqDivision} + "&reqCourseName=" + {dt_Org_Ind.Course_Name} + "&reqType=Induction" But it is showing error- A string is required here. Error in File C:\DOCUME~1\OH3\LOCALS~1\Temp\CR_Org_Ind_Course {71F0A1D4-06B3-4353-AB6C-D59A37
a Question Need help? Post your question and get tips & solutions from a community of 418,472 IT Pros & Developers. It's quick & easy. crystal reports error : a string is required here P: 5 H4nZ83 i created a reports with Crystal reports 8.5 when the reports out a message box pop out with message : a string is required here whats the problem ?? Jan 28 '08 #1 Post Reply Share this Question 3 Replies Expert 5K+ P: 8,435 Killer42 i created a reports with Crystal reports 8.5 when the reports out a message box pop out with message : a string is required here whats the problem ?? Obviously the problem is that a string is required there. I think you need to give us more details. For instance, what version of VB are you using? Can you show us the code? Jan 28 '08 #2 reply P: 5 H4nZ83 Obviously the problem is that a string is required there. I think you need to give us more details. For instance, what version of VB are you using? Can you show us the code? i'm using vb 6 and i make that report using field from a temporary database btw, i have solved it thanks for your attention.. Jan 28 '08 #3 reply Expert 5K+ P: 8,435 Killer42 i'm using vb 6 and i make that report using field from a temporary database btw, i have solved it thanks for your attention.. Ok. Glad to see you got it sorted. :) Jan 28 '08 #4 reply Message Cancel Changes Post your reply Join Now >> Sign in to post your reply or Sign up for a free account. Similar topics RE: Crystal Reports error code 1603 running deployment on a vista mach Crystal Reports formulas and Blank reports Crystal Web ASP hangs on W2003 server, but had worked before. ASP.NET 2.0 Crystal reports failing on server Help with crystal reports in ASP.net Formula error using Crystal Reports for VS.NET 2003 Can the .NET version of Crystal Reports parse a string? Crystal Reports for .NET and Oracle problem - Logon failed Crystal Report unbound fields Browse more Visual Basic 4 / 5 / 6 Questions on Bytes Question stats viewed: 4197 replies: 3 date asked: Jan 28 '08 Follow this discussion BYTES.COM © 2016 Formerly "TheScripts.com" from 2005-2008 About Bytes | Advertise on Bytes | Contact Us Sitemap | Visual Basic 4 / 5 /