Pass string from vb

[sern]

Hi. I wish to pass a string to a formula in Crystal Report 7 from my VB project. I have created a formula in crystal report named Description. In my vb, I have the below code,

rpt.Formulas(1) = "Description='" & str & "'"

where str is the string containing text and apostrophe (').
When I run the system, it show me the error:
Error in formula <Description>.
&quot;Testing 'ABC' Only&quot;
The remaining text does not appear to be part of the formula.

Please help on this. Thanks.

 

[IdoMillet]

A simpler approach is to set a parameter value from VB and use it in your formula.

hth,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[sern]

Thanks IdoMillet. Now the program runs without any errors.