Passing Degree Symbols in a Parameter Field

[Former Member]

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 · Accepted solution]

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

[Former Member · Accepted solution]

The parameter field uses strings, not the number type.

Can we modify your code to be used with strings?