special characters in formula fields

[kim50]

I have a formula field with an special character being returned. This causes the report to crash. Help?

 

[bdreed35]

What is the special character? You may be able to wrap the contents of your formula with the REPLACE function.

Replace (inputString, findString, replaceString)

Substitute inputString with your formula contents.
Substitute findString with the special character.
Substitute replaceString with the a valid character or just double quotes.

~Brian

 

[rosemaryl]

Dear Kim50,

What version of Crystal? What database?

What special character?

What is in the formula?

Why do you need the special character returned?

A little information will go a long way in trying to solve your problem.

ro

Rosemary Lieberman
rosemary@microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

 

[synapsevampire]

Why would you create a formula with a character to crash your report, delete it!

<evil chuckle>

It may be something that the service pack can help resolve:

http://support.businessobjects.com/fix/hot/si75/?ref=default.asp_selectlist

If not, as everyone stated, please post technical information when posting. I'm sure that you're annoyed with Crystal, and a very busy, important person, but these short blurbs do little more than waste your time (not to mention ours).

-k

 

[kim50]

Problem solved . . . thank you all for your reponses.

 

[rosemaryl]

Dear Kim,

Would you mind providing your solution for the edification of the rest of the forum members.

One day someone will do a search because they have a problem with special characters in a formula field. Imagine their frustration to see the solution is: &quot;problem solved&quot;.

Regards,

ro

Rosemary Lieberman
rosemary@microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

 

[kim50]

While my intention was not to waste anyone's time, I have never used this tek-tips before, and did not think about what information I should have included.

My application is using Visual Basic 6.0, and Crystal 9. A report object is being created from Visual Basic using data obtained from high intensive .dll processes. I used the formula field, per Crystal technical support, mainly just to pass the data from Visual Basic to the Crystal .rpt. While I realize parameters are for prompting the user for a value, when I changed the formula field to a parameter field, I no longer had the problem.