I have created a report listing contracts our organization has secured with extrenal vendors.  The report lists Contract Number, Vendor Name ect.  We need to report these contracts on our website and I figured the best way was creating a Crystal report to fetch the information from our financial system.  My problem is that many of our contracts have different cost items (ex: software, maintenance agreements, shipping ...).  We are required to report on these contracts using the highest cost item dollar value.

 

For example, one contract might look like this:

 

Vendor        Contract #        Description        Cost Item $       Total $

ABC Corp    11-1500            Softwate            1500.00            4000.00

ABC Corp    11-1500            Maintenance       2000.00           4000.00

ABC Corp    11-1500            Shipping                500.00           4000.00

 

I don't need all 3 lines, I just need I just need to show line 2 (highest cost item dollar value).  What I did to get this is a group and added a summary (Maximum) for the Cost Item $.  The Vendor, Contract#, and Totals show up fine because the are the same in all 3 lines as well as the summary for the Cost Item $ but the Description shows Software (first one that shows upin the contract) when I need Maintenance to show up.  What formula (if any) could I use to get Maintenance to show up correctly as the Description in the Group? 

 

FYI, the Description field is a Formula Field and all others are Database fields.

 

 

Thanks for any help provided!