Blob fields

[CarlaBee]

Hi,
We enter data into reference fields and description fields to be sorted in different ways. Crysal apparently calls this a "blob" field and won't let me sort on these fields. This is crucial to the way we do just about everything here. Is there any way to make this work?
Thanks.

 

[synapsevampire]

Try posting technical information:

Crystal version
Database/connectivity used
Field types, the names aren't important.

Generally a blob or memo type of field isn't intended to be sorted on, most database architects would avoid this approach.

You may be able to create a SQL Expression which takes the 1st 250 characters or so and sort on that, but this is database and connectivity dependent.

-k

 

[CarlaBee]

Hi K,
The fields are character fields. We're using V9 of Crystal. I'll run what you said by our tech guy and see if he can figure out this.

We currently use Progress Report Builder and are in the process of converting and redesinging in Crystal. RB does allow us to sort on those fields. If I can't with Crystal, it's almost a waste of time.

Thanks for your help.

Carla