Displaying Records with maximum event number for each group in SAP Crystal Reports



I would suggest using this logic to suppress details if the current record is not the record with the maximum amount for the group.

//Suppress Details if the current record is not the record with the maximum amount for the group
{Event.Event_no}<>maximum({Event.Event_no},{Deal_NO})

This will suppress each record except records with the maximum amount each group.

Lakshmi Srinivas
Lakshmi Srinivas

Programmer / Analyst / Technician


Advertisements