Help determining the most recent Date 1

[majordog]

Hi all,
The report has a sub-report that could have multiple records for the specified vehicle. The only way to determine which should be displayed is by the date. Whichever record has the most recent date, should be in report. Can anybody give me some pointers of what I need to do? I know I need to loop through the records, but after that I'm not sure how to determine which is the Most recent date..??

Local NumberVar i;

For i := 1 to COUNT({Vehicle_Coefficients.Date Last Edited}) do

 

[IdoMillet]

A simple approach:

1. Sort your subreport by date (ascending)
2. in the subreport move your fields to the report footer.
3. suppress all other sections.

The report footer always shows the last record in the report... )

Cheers,
- Ido
CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com