Grouping on iMIS Memo Field Crystal Reports

Ever try to use an iMIS memo field for a group in a crystal report? Crystal reports will not allow a memo field to be group on, but do not despair. Here is the work around to enable that field to be group on:
​1) Create a new formula 
2) Then enter the following formula: Left(Order_Meet.UF_9,100)
3) Save the formula
4) Insert a group and the new formula should be available
In the steps above, I referenced the Order_Meet.UF_9 field because I know this is a memo field and number 100 to truncate the field. This formula and grouping was tested in Crystal Reports version 9.

Stay on top of the latest and greatest. Sign up now.

Recommended for you

Blog Subscribe

This will close in 0 seconds