Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Passing Degree Symbols in a Parameter Field

We have a parameter on a crystal report configured to look up data from the database to allow a user to select values.

If someone selects a value that has a degree symbol in it then tries to run the report we get a parameter not valid error.

We see the error when we run the report in Crystal Developer as well.

We are using Crystal XI reporting against an Oracle 10g unicode database. We are using an ODBC connection.

Are we using the right driver for this?

Former Member
Former Member replied

Hi Dan Robinson,

As you said, the report parameter is not able to identity / compare Degree symbol with your database field.

If it is a number field then try the follwoing in record selection formula, if not please place your formula to check the syntax.

Totext(DatabaseField} = Totext({?ParameterValue})

Thanks,

Sastry

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question