This code populates the string
CODE
If strRet <> "" Then strRet = strRet & Chr(13)
strRet = strRet & dr("mrg_group") & ": " & dr("CountPerc")
This code puts the string into a crystal report formula field
CODE
ffdef = crpt1.DataDefinition.FormulaFields.Item("MRGScore")
ffdef.Text = "'" & strMRGScore & "'"
There is no apostrophe single or double quote within the string, but I keep on getting messages about missing end quotes in the crystal report.
String Value:
'Cleaning: 100.00
Cleaning / Nursing: ---
Curtain Ladies: ---
Estates: 84.61
Nursing: ---
Patientline: ---'
Error Code: -2147217383
Error Message:
The matching ' for this string is missing.
Error in formula <MRGScore>.
''Cleaning: 100.00
'
The matching ' for this string is missing.
Does anyone know how to feed a string containing a carriage return/line feed/? into a crystal report formula field?
25 Jun, 2008 - 02:01 AM
| 