Normally you can not filter on a memo field in Crystal Reports. But there is a workaround. Create a parameter parFILTER , type STRING Create a Formula Field and call it frmFILTER In that Formula Field put a formula like this: { table . memofieldname } like "*" & {? parFILTER } & "*" Then filter on this Formula Field Pick: IS TRUE The memo field now will be filterd by the text given in the parameter parFILTER .
Blog over software als Access, Excel, SQL, Crystal Reports, Report Builder, Word, VBA, elfstedentochten en andere regionale zaken.