I am new here and do not typically create Crystal Reports but here I am.

 

My question is how can I do a group by on essentially a %like% statement?

 

Below is a mockup of my data.

 

Vanoork

**Pen

**Pen

Vanoork

**Pen Ltd

Blank

Example

 

 

I want to group anything with Pen in it and I want to group Blank and Example into their own seperate group.  Everything else then would go into a seperate group.  I would have three groups, one for Pen, one for Blank and Example, and then the last one as a catch-all.  Any ideas?  Thanks