Hi, I have these data:

Person A: Category A, Category B and Category C

Person B: Category A

Person C: Category B, Category C

I would like to have 1 category for each person only and the order is Category B --> Category C --> Category A

I try to use "if-then-else" in the fomula, but it didn't come out with what I want.

What should I do in this case?

Thanks so much

Are the categories the same field on different rows or different fields on the same row?  I'm assuming same field/different rows, since that's the one most likely to cause problems.

Try creating a group on the constituent and then a group on the category making the order "specified order" and specify B, C, then A.  Put the category in the constituent's group header.

You won't be able to use your single category to do groupings, because it depends on other groupings to display properly.

Drew

Thanks for your help.

Is it possible to put the groups in cross-tab? I try to put them into the cross tab, however it will double count the number of people.

e.g. Person A: Category A, Category B. Then the Crystals Report will count Person A twice.

Thanks in advance.

No.  Crystal Reports does not allow summary information in the row or column headers.

The place to take care of this is your export.  Instead of having one field with all three values, you need to have three fields restricted to one of each of the three values.

Drew