Re: SELECT DISCTINCT ability in Crystal Reports 5?

Dale E. Reed Jr. ( (no email) )
Thu, 04 Jun 1998 22:48:37 -0700

Josh Hillman wrote:
> Does anyone know if there's a way to implement the "DISTINCT" feature of a
> SQL SELECT statement in Crystal Reports 5.0 reports? I created a CR5
> report that displays the following payment information for any requested
> date:

You need to create a second group to show the distinct, and hide the
details section. I modified your report to output what I believe is
what you are looking for. Its a CR 6.0, but it should work find on
CD 5.0 as well. Its in /emerald/contrib/reports.

-- Dale E. Reed Jr.  (       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |