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.
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.
