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
- Create a group on Customer Name
- 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})
- 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