SAP Knowledge Base Article - Public

1701825 - How to make a report that shows only oldest date information per customer


How to make a report that showing only oldest dated information per customer


Crystal Reports 2008

Reproducing the Issue

Create a report on Xtreme Sample database.


  1. Create a group on Customer Name
  2. Right-click the details section -> go to Section Expert -> click on the formula button beside Suppress and use this formula:

{Date_Field} < Maximum({Date_Field },{Customer_Name_Field})

  1. And, then suppress the Group Header and Group Footer sections


Show only oldest data, show only oldest dated information per customer, date formula, oldest data formula, crystal reports , KBA , BI-RA-CR-DSL , Crystal Reports on C++ Data Semantic Layer (ClassicUniverse) , How To


Crystal Reports 2008 V1