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

SAP Knowledge Base Article - Public

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

Symptom

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

Environment

Crystal Reports 2008

Reproducing the Issue

Create a report on Xtreme Sample database.

Resolution

  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

Keywords

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

Product

Crystal Reports 2008 V1