Select Distinct Records

[WillRiley]

Please can anyone help me with this one... hopefully an easy
one for some of you...

My table contains a number of records for the field
"groupid" (i.e. a new recod with the same groupid is
created whenever one of the other fields gets updated)

I am querying a table and want to select only the latest
details (most up to date) for each "groupid"

Can anyone help me with the 'select' statement
for this.....

thanx. will

 

[kenhamady]

You can't write or change the SELECT statement inside Crystal Reports. Crystal has to generate the SELECT for a report, although you can write it in your database (in a view or SP) or in the CR SQL Designer and report off of that.

In CR you have to Group by the GroupID and enter a group selection formula that says:

{Date} = Maximum ({date}, {GroupID})

It will bring all dates back to CR but only display the last one. Use running totals to get good grand totals
Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com