Sort on Group Formula

[Dominican1979]

Hello Everyone,

Thanks in advance for reading my post. So here's what I'm trying to do. I have an International Invoice report that lists customers and products. I have two groups. The first group I do it on customer number. The second group I do it on product type based on the formula below:

if {Table.ProdType} = 1 or {Table.ProdType} = 2 Then
"Total Frames:"
else if {Table.ProdType} = 4 Then
"Total Advertising Materials:"
else "Total Spare Parts:"

Now this is how I have the report broken down:

Report Header (company logo, address info, etc)
Page Header (suppressed)
Group Header #1 (labels: invoice no, item no, description, qty, etc)
Group Header #2 (I just have this section colored in section expert)
Details
Group Footer #2 (Here I have the group names based on formula above, qty subtotal, amount subtotal)
Group Footer #1 (suppressed)
Report Footer (Qty grand total, amount grand total, page #, etc)

Here's my problem: I want to be able to sort the groups any way I want based on the product type. For instance right now the report is sorted like this:

Total Advertising Materials
Total Frames
Total Spare Parts

but I want to sort it like this:

Total Frames
Total Spare Parts
Total Advertising Materials

When I look at the group sort expert option, it is grayed out, then I looked at the record sort expert and the report is alerady sorting by group #1 then by group #1 and I can't remove them, I can just add. Any ideas? Thanks a lot a gain.

Crystal Reports XI

 

[Dominican1979]

Hello everyone,

I just figured it out, I went to group expert and clicked on the options for the product type group, then picked the sorting in specified order, and that did the trick. Thanks a lot.