Combine groups

[msteinblock]

I have a report that shows a group that currently has say 12 entrys. I would like to have the report show entry A, entry B, and All Others. Is is possible to combine the entrys when grouping? Or does this require doing something like 3 subreports? I am new to crystal, just trying to figure out the best way to do this.

Thanks!

 

[lbass]

Create a formula in the field explorer->formula->new and enter:

if not({table.field} in ["A","B"]) then
"All Others" else
{table.field}

Insert a group on this formula. Another option would be to insert a group on the field itself, choose "specified order" and add A and B to the list, then go to the "Other" tab and say Put all others in a group: All Others.

-LB

 

[msteinblock]

I did the last option and it worked! Thanks!!

Here is another question. I was using a formula to rename the data on the groups. When I chose the specified order, the add formula to group option is no longer usable.

 

[lbass]

You can just create a formula in the field explorer, and use it instead of the groupname.

-LB

 

[msteinblock]

I am not really following you on that one....but I will play with it some more in the morning.

Thanks again for the help.