Print Page | Close Window

Selecting Last Record

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
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=14555
Printed Date: 20 Apr 2025 at 10:35am


Topic: Selecting Last Record
Posted By: lowester
Subject: Selecting Last Record
Date Posted: 30 Sep 2011 at 9:28am
Hi,  I have a database full of clients and events.. Example client 123 had and event on 08242011 in an Outpatient Program.  Im trying to pull the last event each client had..  Example if client 123 had 3 events.. 1 in june, 1 in july, 1 in august.. i want the report to show only the 1 for august since is that most recent event.  Looking for some guidance on how to do this.. thanks!
 
There are also other clients in the database and want the report to pull the most recent event for each individual client..


Print Page | Close Window