Re: SELECT DISCTINCT ability in Crystal Reports 5?

Josh Hillman ( (no email) )
Fri, 5 Jun 1998 10:51:29 -0400

> From: Dale E. Reed Jr. <>
> 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.

Thanks for taking the time to look at that. I downloaded your edited
version and it appears that the output is pretty close to the original
(except yours doesn't repeat everything for multiple InvoiceItems, which
was what I was trying to prevent it from doing). I noticed that the
group/grand totals are incorrect, but that's probably still totalling
totalling Invoice.Amount (while repeating some of the Invoice.Items):
inv. 1234 AmountDue: $60.00 (3 $20.00 InvoiceItems)
inv. 1235 AmountDue: $15.00 (1 $15.00 InvoiceItem)
Total: $195.00 (instead of $75)

Since I don't have CR5 on any machines in the office, I'll have to fiddle
with the totals when I get home tonight.

Thanks again!

Josh Hillman

> 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
> > date:
> --
> Dale E. Reed Jr. (
> _________________________________________________________________
> IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs
> Internet Solutions for Today |