Crystal Report Error The Matching For This String Is Missing
Join INTELLIGENT WORK FORUMSFOR COMPUTER PROFESSIONALS Log In Come Join Us! Are you aComputer / IT professional?Join Tek-Tips Forums! Talk With Other Members Be Notified Of ResponsesTo Your Posts Keyword Search One-Click Access To YourFavorite Forums Automated SignaturesOn Your Posts Best Of All, It's Free! Join Us! *Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. 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! Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.Just copy and paste the BBCode HTML Markdown MediaWiki reStructuredText code below into your site. Business Objects: Crystal Reports 2 Data Access Forum at Tek-Tips HomeForumsProgrammersReporting SolutionsBusiness Objects: Crystal Reports 2 Data Access Forum CRViewer error, "The matching ' for this string is missing." thread766-59655 Forum Search FAQs Links MVPs CRViewer error, "The matching ' for this string is missing." CRViewer error, "The matching ' for this string is missing." BigAl1 (Programmer) (OP) 2 Mar 01 10:44 In this environment, we call and pass parameters to Crystal .rpt files from VB.For some reports (not all), I'm suddenly getting the CRViewer error, "The matching ' for this string is missing."Other programmers in same application, calling the same report do not get this error.I have not changed my project references or moved / deleted any dll's.Not sure why I'm now receiving this error.These were working fine until recently.Ideas? RE: CRViewer error, "The matching ' for this string is missing." kenhamady (Instructor) 2 Mar 01 12:41 Are you passing any strings to the report that might have quotes embedded in them? Ken Hamadyhttp://www.kenhamady.com/Crystal Reports Training/Consulting and a Quick Reference Guide to VB/Crystal (including ADO) RE: CRViewer error, "The matching ' for this string is missing." BigAl1 (Programmer) (OP) 5 Mar 01 12:04 No.The only parameter I'm passing is an ID field, declared as integer in vb.The data type of the parameter in Crystal is a number. RE: CRViewer error, "The matching ' for this string is missing." kenhamady (Instructor) 5 Mar 01 12:44 If other reports work, then the report is probably not the problem, something is probably being passed in that is causing the error.If you don't pass the parameter, do you still get the error? Ken Hamadyhttp://www.kenhamady.com/Crystal Reports Training/Consulti
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 > Passing multi-line string parameter to Crystal Reports Want to Advertise Here? http://www.tek-tips.com/viewthread.cfm?qid=59655 Solved Passing multi-line string parameter to Crystal Reports Posted on 2012-06-04 Crystal Reports Visual Basic Classic 1 Verified Solution 5 Comments 3,365 Views Last Modified: 2012-06-05 When I try to pass a multi-line string parameter from VB6 to Crystal Reports I get the following error: "The matching ' for this string is missing". How https://www.experts-exchange.com/questions/27743819/Passing-multi-line-string-parameter-to-Crystal-Reports.html can I replace the newline character in VB6 with a valid character in Crystal Reports? 0 Question by:MadlenY Facebook Twitter LinkedIn Google LVL 22 Active today Best Solution byIdoMillet Pass the string without a new line character. Instead, replace the new line character with some special text (such as "
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About http://stackoverflow.com/questions/324776/crystal-reports-passing-multiline-parameter-values Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the https://bytes.com/topic/visual-basic/answers/633924-help-multiline-textbox-pass-crystal-reports Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Crystal Reports: Passing Multiline Parameter Values crystal report up vote 2 down vote favorite I want to pass some parameters to a Crystal Report like this: ReportDocument.DataDefinition.FormulaFields[parameterName].Text = 'Text'; This workes fine unless I want to pass a multiline textbox from ASPX (containing \n and \r chars.) The reportviewer reports that "The matching ' for this string is missing.". Is there any example/list/suggestion how to parse the (multiline) text and make this work? Thanks, Stefan crystal report error c# .net asp.net crystal-reports share|improve this question edited Dec 26 '08 at 8:19 splattne 68.4k39179234 asked Nov 27 '08 at 22:57 Stefan add a comment| 5 Answers 5 active oldest votes up vote 3 down vote If you want to retain line breaks you should replace them with something obscure as described by sindre j. In order for the line breaks to display correctly in Crystal Reports you need to replace the obscure characters in a Crystal Report formula with html breaks. Then add your formula field to the report and right-click, select 'Format Field', select the 'Paragraph' tab, and change the 'Text Interpretation' to 'HTML Text'. You also need to make sure the 'Can Grow' attribute is checked on the 'Common' tab. See the example formula below: "" + Replace({?ParameterField}, "___", "
") + "
+ Ask a Question Need help? Post your question and get tips & solutions from a community of 418,472 IT Pros & Developers. It's quick & easy. Help with Multiline TextBox to pass to Crystal Reports. P: 1 dhavalmajmundar Hi, I am passing the value of the Multiline Text Box from VB to Crystal. Everything was ok until the User Pressed the Enter Key to separate the line in the Multiline Textbox, Pressing Enter causes the VB to throw a msg before opening the Crystal. The Error Says: Error Generating Report. Error in Formula. In Error, it shows the ''line 1 and than in next line just the single quote character ' like this. and in the last line it shows The matching ' for this string is missing and an ok button and it goes back to the VB application. I need this urgently to turn back to the customer and donno what i have to do to fix this. Please help me if anybody can. Thank you, Dhaval. Apr 17 '07 #1 Post Reply Share this Question 1 Reply Expert 5K+ P: 8,435 Killer42 I'm a bit unclear on some of this. Is the problem that there is a line break in the text? Or that the user is leaving a blank line between lines, or what? If there are not suppoed to be any line breaks, then maybe you could get away with simply turning off the Multiline property. Perhaps you can just run through the text in your VB code and check for whatever situation is a problem, before passing it to Crystal Reports. Apr 17 '07 #2 reply Message Cancel Changes Post your reply Join Now >> Sign in to post your reply or Sign up for a free account. Similar topics Crystal Reports Help TextObject Multiline Help with error: Object reference... How to have multiple worker threads submit to one final processing queue? - HELP Make Reports that can pass parameters at Run-time? :: ASP.NET + CR.NET HELP PLS! Configuring and deploying Crystal.NET reports Help needed in access to Crystal reports.. HELP on Changing Crystal Report sql query at run time via vs.net. Pass variable to Oracle Query form Crystal Reports Browse more Visual Basic 4 / 5 / 6 Questions on Bytes Question stats viewed: 2636 replies: 1 date asked: Apr 17 '07 Follow this discussion BYTES.COM © 2016 Formerly "TheScripts.com" from 2005-2008 About Bytes | Advertise on Bytes | Contact Us Sitemap | Visual Basic 4 / 5 / 6 Answers Sitemap | Visual Basic 4 / 5 / 6 Insights Sitemap Follow us to get the Latest Bytes Updates