memo fields

[eguthrie]

In the record selection formula, I need a way to filter out records that have specific text entered in a particular database field. But the database field I'm looking at is a memo field, which can't be used in Crystal formulas.

Does anyone know of a way around this?

Thanks.
-Evelyn

 

[rosemaryl]

Dear Evelyn,

If it is always only this value that you will want to test for, probably the easiest is to add a field to the database that checks to see if the value is there and indicates a Y/N.

As far as I know, the only way a memo field can be used in an actual formula is if you are checking for nulls as in:

Isnull({MemoField})

You have to manually type the field in as it will not show up in the field list in the formula editor!

ro Rosemary Lieberman
rosemary@microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

 

[rhinok]

Unfortunately, you can't really get around the memo issue within Crystal Reports directly:-(

You can, however, base your report on a View, Crystal Query or Stored Procedure that excludes these records in its 'Where' clause.

Hope this helps!

 

[AndrewBaines]

If you have a view converting the memo to CHAR(254) it works OK.

 

[eguthrie]

Thanks to everyone for their helpful responses. I'm probably going to change the report to base it on a view that excludes the records I want filtered out.
-Evelyn