Print Page | Close Window

Select a correct string based on minimum date

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=9286
Printed Date: 30 Apr 2024 at 10:03am


Topic: Select a correct string based on minimum date
Posted By: Jyri
Subject: Select a correct string based on minimum date
Date Posted: 04 Mar 2010 at 12:55am
Hey all,
 
I have a situation shown below :
 
8C17NHLUT11  29.4.2008 17:14          Joe Black
8C17NHLUT11 30.4.2008 8:13  Samantha Red
 
So there is invoice number, action date (when they have made changes to invoice), employee name
 
What I would want is that when I make a group for invoicenumber, formula would return employees name which have made the change first. So it would look like this :
 
8C17NHLUT11            Joe Black   ( because action date is 29.4.2008)
 
If anyone could help, would be awesome.
 
If I couldn't expalain the situation, please don't hesitate to ask for clarification. i would really need a solution to this.
 
- Jyri


Replies:
Posted By: razzak
Date Posted: 04 Mar 2010 at 5:15am
HI Jyri ,
 
click on group expert select your group(i.e Invoice Number) then click on option button in first drop down select action_date field and in second drop down select descending.
 
 


-------------
Razzak Sayyed


Print Page | Close Window