MAX function at detail level

[emallon]

I have a table containg product detail records. Each product has multiple records of the exact same data except for two fields: prod_cost and cost_key. When a product's cost changes, the cost_key is incremented and a new detail record is placed in this table for that product.

How do you select only the records with the MAX cost_key for each product?

 

[kenhamady]

Group by product.
Select the cost key and insert a summary field that is the max key for each group.

Then put something like the following in the Group Selection Formula:

{key} = Maximum({key}, {product} ) Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/

 

[emallon]

Thanks. It worked perfectly.