Crystal XI Details Grouping

[Sh1999]

In Crystal Reports XI R2, I would like to split my details into two groups based on conditions. Currently the details show all parts and their names and costs in detail. I would like for products with a Product line of 0-99 to be summarized into a group labelled "Wood" and all parts with a product line 99-200 to be summarized into a line for "Metal." So essentially instead of 50+ part lines in the details section there would be 2 lines, Wood and Metal with the totals for the parts that fall into their criteria.

Tried creating a group with subgroup like group 1a and 1b but that did not work.

[DellSC]

You'll create a formula similar to the following (I'm assuming that part number is a numeric field...)

If {table.PartNumber} >= 0 and {table.PartNumber} <= 99 then 
  "Wood"
else
  "Metal"

Group on this formula and configure the group to sort descending if you want Wood to be on the report first.

-Dell