SELECT DISCTINCT ability in Crystal Reports 5?

Josh Hillman ( (no email) )
Thu, 4 Jun 1998 17:55:52 -0400

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:
InvoiceID, Name, Company, Amount Due, Amount Paid
Grouped by MasterAccounts/Groups.GroupName
Totals for each Group
Grand totals for the date specified.

For our needs, it's perfect EXCEPT for the fact that it duplicates many of
the rows because of multiple InvoiceItems associated with some of the
InvoiceIDs. At the following address are two of these reports--one that
works just fine (if I leave out the Invoice.Amount (Amount Due) and leave
out the Invoices/InvoiceItems.InvoiceID); the other displays the multiple
rows for any invoice that contained more than one InvoiceItems.ItemID.

http://hillman.talstar.com/temp3/
Daily-Payments.rpt (works correctly, but lacks InvoiceID
and Invoice.Amount
Daily-Payments2.rpt (doesn't work correctly)

Does anyone know how to fix this? It seems like something so simple, yet I
can't figure it out. I have a plain SQL script that performs all of this
stuff correctly using SELECT DISTINCT, but I can't seem to add "DISTINCT"
to the report SQL query.

Thanks for any help...

Josh Hillman
hillman@talstar.com