Crystal Report group on max date
Posted on 2014-12-29
In Crystal Report XI R2 I have a main report and in it I have sub report. In sub report I have next fields:
- Student_ ID ,
- Student _Action_ Date,
- Note_ Date
One student could have on one student Action Date several notes , each note has its note date.
So I need to pull out one field (Note).
Note for each student on Latest Action date that has latest Note_Date (Date time) value.
I assume that I should make two groups First group : Studen_ID (this is link field with main report) , Second group :Student _Action _Date. Somehow I need max Student _Action_Date and Max Note_Date.
How to arrange selection criteria to get this result?