I have a report that I send to customers which is a price list. It has columns for item #, their sku # (formula field), price, their suggested sell price (formula field) and description. I would like to group these items by the product type, the product type could be established based of a database item such as the product code (this is how we establish a grocery item from a pet item) or preferably I would like to build the grouping based on a formula that says
if the item is one of the following part #'s then put into group "Horse Products"
if the item is one of the following part #'s put into group "Pet Products" etc etc

Either way thus far I have been unable to generate any sort of proper grouping in either way, please help.

I am not sure how to build a group based on a formula though. When I go to group field and select - insert group, it gives me the option to pick only from database fields not formula fields?

Ok So it kind of worked but not really. So now I have this:
Horse Products
34437360EA 700100591 BMZ 3KG Yes 30.13000 48.40
(13)
Horse Products
3555 BBD 223254 HORSE BLOCK 25KG Yes 29.76000 34.33
(13)
Horse Products
3589 HDH 507496 Apple chunks 10Kg Yes 22.26000 25.76
(13)
Horse Products
F8200355900EX20 507497 ATHLETE HORSE 20kg Yes 23.41000 26.96

As you can see what it has done is added the heading for my group above each item that fits in it but what I want is this

Horse Products
34437360EA 700100591 BMZ 3KG Yes 30.13000 48.40
(13)
3555 BBD 223254 HORSE BLOCK 25KG Yes 29.76000 34.33
(13)
3589 HDH 507496 Apple chunks 10Kg Yes 22.26000 25.76
(13)
F8200355900EX20 507497 ATHLETE HORSE 20kg Yes 23.41000 26.96

I created a formula field this is the formula I used :
if{INVENTORY.INV_DESCRIPTION}="SIMPLIC-T PRO 25kg"
then"Horse Products" else
if{INVENTORY.INV_DESCRIPTION}="SIMPLIC-T FIBRA 25kg"
then"Horse Products" else
if{INVENTORY.INV_DESCRIPTION}="SIMPLICI-T ORIGINAL 25kg"
then"Horse Products" else
if{INVENTORY.INV_DESCRIPTION}="SIMPLICI-T PRO GRAIN 25kg"
then"Horse Products" else
if{INVENTORY.INV_DESCRIPTION}="SIMPLICI-T NATURE 25kg"
then"Horse Products" else
if{INVENTORY.INV_DESCRIPTION}="EVOLUTION MATERNITY 20kg"
then"Horse Products" else
if{INVENTORY.INV_DESCRIPTION}="EVOLUTION JUVENILE 20kg"
then"Horse Products" else
if{INVENTORY.INV_DESCRIPTION}="EVOLUTION SPORT ELITE 20kg"
then"Horse Products" else
if{INVENTORY.INV_DESCRIPTION}="EVOLUTION SENIOR 20kg"
then"Horse Products" else
if{INVENTORY.INV_DESCRIPTION}="OMOLENE MATERNITY 300 20kg"
then"Horse Products" else
if{INVENTORY.INV_DESCRIPTION}="OMOLENE SPORT 200 20kg"
then"Horse Products" else
if{INVENTORY.INV_DESCRIPTION}="OMOLENE SPORT PLUS 20kg"
then"Horse Products" else
if{INVENTORY.INV_DESCRIPTION}="OMOLENE SENIOR ACTION 20kg"
then"Horse Products" else
if{INVENTORY.INV_DESCRIPTION}="VELOCI-T TRADITION 20kg"
then"Horse Products" else
if{INVENTORY.INV_DESCRIPTION}="VELOCI-T MAX 20kg"
then"Horse Products" else
if{INVENTORY.INV_DESCRIPTION}="EQUILIBRIUM MATERNITY XT 20kg"
then"Horse Products" else
if{INVENTORY.INV_DESCRIPTION}="EQUILIBRIUM SPORT XT 20kg"
then"Horse Products" else
if{INVENTORY.INV_DESCRIPTION}="EQUILIBRIUM TRIMAX 20kg"
then"Horse Products" else
if{INVENTORY.INV_DESCRIPTION}="EQUILIBRIUM PRO PLUS 25kg"
then"Horse Products" else
if{INVENTORY.INV_DESCRIPTION}="EQUILIBRIUM FIBRA PLUS 25kg"
then"Horse Products" else
if{INVENTORY.INV_DESCRIPTION}="EQUILIBRIUM FIBRA CLASSIC 25kg"
then"Horse Products" else
if{INVENTORY.INV_DESCRIPTION}="EQUILIBRIUM INTEGRI-T 25kg"
then"Horse Products" else
if{INVENTORY.INV_DESCRIPTION}="EQUILIBRIUM EQUILIZER 25kg"
then"Horse Products" else
if{INVENTORY.INV_DESCRIPTION}="EQUILIBRIUM OPTIMAL 25kg"
then"Horse Products" else
if{INVENTORY.INV_DESCRIPTION}="Apple chunks 10Kg"
then"Horse Products" else
if{INVENTORY.INV_DESCRIPTION}="APPLE CHUNKS - 1 kg Package"
then"Horse Products" else
if{INVENTORY.INV_DESCRIPTION}="ATHLETE HORSE 20kg"
then"Horse Products" else
if{INVENTORY.INV_DESCRIPTION}="HORSE BLOCK 25KG"
then"Horse Products" else
if{INVENTORY.INV_DESCRIPTION}="BMZ 3KG"
then"Horse Products" else
if{INVENTORY.INV_DESCRIPTION}="HORSE PLUS 3KG"
then"Horse Products" else
if{INVENTORY.INV_DESCRIPTION}="GOLDEN GROWENA 25kg"
then"Backyard Products" else
if{INVENTORY.INV_DESCRIPTION}="GOLDEN LAYENA L 25kg"
then"Backyard Products" else
if{INVENTORY.INV_DESCRIPTION}="GOLDEN LAYENA TEX 25kg"
then"Backyard Products" else
if{INVENTORY.INV_DESCRIPTION}="GOLDEN STARTENA (layers - extra small crumble) 25kg"
then"Backyard Products"


I went to group name fields, clicked insert group, and chose to group by the formula field in ascending order.

I would do it a different way.

if {INVENTORY.INV_DESCRIPTION}="SIMPLIC-T PRO 25kg" or
{INVENTORY.INV_DESCRIPTION}="SIMPLIC-T FIBRA 25kg"  or
if{INVENTORY.INV_DESCRIPTION}="SIMPLICI-T ORIGINAL 25kg" or
...
then then"Horse Products" else
if {INVENTORY.INV_DESCRIPTION}="GOLDEN GROWENA 25kg or
{INVENTORY.INV_DESCRIPTION}="GOLDEN LAYENA TEX 25kg or
{INVENTORY.INV_DESCRIPTION}="GOLDEN STARTENA (layers - extra small crumble) 25kg"
then"Backyard Products"


Probably should have another else to pick up anything you might of missed.

You probably could do the same thing (sorta) in the group expert, but it is a bit cumbersome with this many values.