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

When working with SAP Crystal Reports, you often need to display only the records with the maximum event number for each group. This is a common requirement when you want to show the latest or highest event for each deal or group in your report.

The most effective approach is to use the suppress formula to hide details that don't match the maximum event number criteria for their respective group.

Suppress Formula Method

I would suggest using this logic to suppress details if the current record is not the record with the maximum event number for the group ?

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

How It Works

This formula compares the current record's Event_no with the maximum Event_no in the same Deal_NO group. If they don't match, the record gets suppressed.

The maximum({Event.Event_no}, {Deal_NO}) function calculates the highest event number within each Deal_NO group, ensuring that only the record with the maximum event number remains visible for each group.

This will suppress each record except records with the maximum event number for each group, giving you a clean report showing only the latest events per deal.

Implementation Steps

To implement this solution ?

1. Right-click on the Details section in your Crystal Report
2. Select Section Expert
3. Click on the Suppress tab
4. Enter the suppress formula provided above
5. Click OK to apply the changes

Conclusion

Using the suppress formula method effectively filters your SAP Crystal Reports to display only records with maximum event numbers per group, providing a cleaner and more focused report output.