woensdag 9 oktober 2013

Crystal Reports: Filtering on Text from a Memo Field

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.
Een reactie plaatsen