{var%20f='http://v.t.sina.com.cn/share/share.php?appkey=1515056452',u=z||d.location,p=['&url=',e(u),'&title=',e(t||d.title),'&source=',e(r),'&sourceUrl=',e(l),'&content=',c||'gb2312','&pic=',e(p||'')].join('');function%20a(){if(!window.open([f,p].join(''),'mb',['toolbar=0,status=0,resizable=1,width=440,height=430,left=',(s.width-440)/2,',top=',(s.height-430)/2].join('')))u.href=[f,p].join('');};if(/Firefox/.test(navigator.userAgent))setTimeout(a,0);else%20a();})(screen,document,encodeURIComponent,'','','https://www.manongdao.com/data/attach/logo/logo.png', '推荐 男人必须洒脱 的问题《Crystal Reports: Passing Multiline Parameter Value》','https://www.manongdao.com/q-864214.html','页面编码gb2312|utf-8默认gb2312'));){kind=link}
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
You have to replace the \r\n pair with something obscure before passing it to the report, then make a crystal formula that converts it back to cr-lf pair in the report.
Example with converting cr-lf to three underscores
C#
ReportDocument.DataDefinition.FormulaFields[somefield].Text = textWithCrLf.Replace("\r\n","___");
Crystal formula:
Replace({somefield}, "___", chr(13))
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:
"<html>" + Replace({?ParameterField}, "___", "<br>") + "<html/>"Hope this helps.
Regardless of your parsing technique, you may want to use the Parameter's DefaultValues or CurrentValues collections. The DefaultValues collection populates the list of available values. The CurrentValues collection populates the list of selected values.