fields in db not showing 1

[cc5305]

I'm trying to use the formula editor to filter out certain records in the database. But the problem is that when I go into the Formula editor, the field that I need to use in the table does not show up in the tree. The confusing thing is that the field does show up if I am just adding the database field. If I hardcode the name of the field in the formula editor, I get the "Blob field or Message field cannot be used in formulas". What can I do to use that field in the Formula editor? I can't even see that field anywhere else using the other tools. Does anyone know any type of solution to this? [sig][/sig]

 

[kenhamady]

There are certain data types that can only be displayed, and can't be evaluated in formulas. These included Blob fields and Memo fields. Check the datatype of this field. If it is a Blob or a Memo then it can only be printed on the page. It can't go in any formulas.

The only exception is that for Memos (possibly Blobs) you can write a formula to check to see if the field is null:

IsNull ({table.blob})

But you can't use this for selection criteria.


You would have to change the data type of the field in the database, or in a view, to work with it in Crystal. [sig]<p>Ken Hamady-

http://www.kenhamady.com<br><a

href=

http://www.kenhamady.com/>Crystal

Reports Training by Ken Hamady</a><br>[/sig]