how do I return only the first record of a set ?

[bogojugolev]

Hi,
I'm trying to return only the first occurence of records meeting certain criteria. I'd like to bring back only the earliest date of all records where customer_ID = x. Is Crystal able to use a "minimum" definition in the record selection area and if so, how would the selection statement appear?

Thanks for any guidance

 

[synapsevampire]

This would require grouping of all fields and turning on perform grouping on the server, as to build a SQL Statement akin to real SQL.

Here's CD's paper on this:

http://support.crystaldecisions.com/library/kbase/articles/c2009635.asp

Note that min() should work the same as their example of sum().

A simple cheat is to let Crystal determine the lowest date, though you'd have to slug through all rows in Crystal.

Group by Customer and sort by date.

Place the date in the Customer Group Header, the first date will be displayed, which is the lowest (min).

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[bogojugolev]

Thanks Synapse, I'll check it out