Why my column not available in Choose Field list

[TaTips]

Hello:

I am in the process of defining parameters(Selection Expert) for my report.

When I click on the "New" tab I am prompted with the "Choose Field" window.

The problem is that the database field that I want to use as a parameter is not in the available list.

When I try to hardcode the field in the "Show Formula" window it complains that "A Blob field or memo field cannot be used in a formula".

Any ideas about this one please ?

I've noticed that fields of type CHAR are available whilst type VARCHAR are not.

thanks.
Nick.

 

[FVTrainer]

If your field exceeds 254 characters, it will be treated as a memo field by Crystal. In versions of Crystal prior to version 9, you are not allowed to use memo fields in formulas. Are your varchar fields greater than 254 characters?

 

[TaTips]

Thank you FVTrainer. You confirmed my suspicion.