Crystal Report Error In Formula 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 error in formula record_selection a string is required here created out of the Business View data sourceand creating a new report out crystal reports a string is required here date of theODBC data source connection.There is a formula that works in the Business View but when I create the same
A Boolean Is Required Here Crystal Report Error
formula in ODBC I get the "A string is 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
Crystal Reports If Then Else A String Is Required Here
I get the error message. I really appreciate any guidances.Thank you, Thanh 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 crystal reports a string is required here. details errorkind Status: Offline Posts: 11 Posted: 25 Jun 2012 at 7:17am Hi Kevlray, Thank you so much 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.
SAP Crystal ReportsWhere is this place located?All Places SAP Crystal Reports 12 Replies Latest reply: Sep 29, 2010 7:27 PM by sharon towler Tweet A string is required here Reddy boc Sep
Convert To String In Crystal Report Formula
27, 2010 2:48 PM Currently Being Moderated Hi guru,When I am running crystal reports viewer a string is required here a report the error is poping up " A string is required ". After clicking the OK, it is the string is non-numeric crystal reports taking me to Forumla editor{CLARITY_TDL_VIEW.POST_DATE} in {?Select Start Denial Post Date} to {?Select End Denial Post Date}After doing some research, I tried using ToText and Cstr functions, But no luck. http://www.crystalreportsbook.com/Forum/forum_posts.asp?TID=16845 Please help me outRegardsR 3545Views Re: A string is required here Manavendra Bhatnagar Sep 27, 2010 3:04 PM (in response to Reddy boc) Currently Being Moderated Hi R,Please check the format you are receiving date in. If the date format is DD/MM/YYYY, Crystal does not recognize it as a date and you will have to use the MID, LEFT & https://scn.sap.com/thread/1793905 RIGHT functions to break the date and rearrange it in MM/DD/YYYY format before you can use the cdate function.Thanks & regards,Manu. Alert Moderator Like (0) Re: A string is required here Reddy boc Sep 27, 2010 3:09 PM (in response to Manavendra Bhatnagar) Currently Being Moderated Thanks for replying me, Please let me where to check the format where I am new to CR. Is it in the Back end, If it is on the back end then how to convert it ??Will the ToText and Cstr functions works to convert ??Thanks in advance again..... Alert Moderator Like (0) Re: A string is required here Manavendra Bhatnagar Sep 27, 2010 3:12 PM (in response to Reddy boc) Currently Being Moderated Hi R,What is the back end you are working with? Is the Crystal Report built on a BEx query?Thanks & regards,Manu. Alert Moderator Like (0) Re: A string is required here Reddy boc Sep 27, 2010 3:18 PM (in response to Manavendra Bhatnagar) Currently Being Moderated The back end is SQL Server 2008, Just now I check in the back
Tips/Tricks Top Articles Beginner Articles Technical Blogs Posting/Update Guidelines Article Help Forum Article Competition Submit an article or tip Post your Blog quick answersQ&A Ask a Question View Unanswered Questions View http://www.codeproject.com/Questions/596370/AddplusHyperlinkpluswithplusquerystringplusinplusc All Questions... C# questions Linux questions ASP.NET questions SQL questions VB.NET questions discussionsforums https://www.experts-exchange.com/questions/27592766/Crystal-Reports-A-String-is-required-here-issue.html All Message Boards... Application Lifecycle> Running a Business Sales / Marketing Collaboration / Beta Testing Work Issues Design and Architecture ASP.NET JavaScript C / 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 crystal report Android iOS Mobile SharePoint Silverlight / WPF Visual Basic Web Development Site Bugs / Suggestions Spam and Abuse Watch features Competitions News 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 is required here 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-D59A371EFA6C}.rpt: Error in 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"' Please help me to find out what is wrong Posted 21-May-13 20:14pm Sweetynewb835 Updated 22-May-13 0:47am v5 Add a Solution 1 solution Rate this: Please Sign up or sign in to vote. Solution 1 Accept Solution Reject Solution error due to... ToNumber ({dt_Org_Ind.ind_div_id}) it should be... ToText ({dt_Org_Ind.ind_div_id}) Happy Coding! :) Permalink Posted 22-May-13 1:11am Aarti Meswania27.2K Add a Solution Add your solution
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 BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > Crystal Reports - A String is required here issue Want to Advertise Here? Solved Crystal Reports - A String is required here issue Posted on 2012-02-17 Crystal Reports Query Syntax 3 Verified Solutions 5 Comments 2,409 Views Last Modified: 2012-02-22 Hello experts, I have a formula field that holds a data string that I have a need to convert to a number. However, that field is sometimes blank. It is also, sadly, a subreport link, so whenever that field is null it kills my entire report. Any way around this? if isnull({person.external_id