Re: SELECT DISCTINCT ability in Crystal Reports 5?

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

Messages sorted by: [ date ][ thread ][ subject ][ author ]
Previous message: Peter A. Sang: "DNS Management for Emerald?"
Next message: Dale E. Reed Jr.: "Re: Emerald would not issue a Renewal-Invoice"
Maybe in reply to: Josh Hillman: "SELECT DISCTINCT ability in Crystal Reports 5?"
Next in thread: Josh Hillman: "Re: SELECT DISCTINCT ability in Crystal Reports 5?"

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.  (daler@iea-software.com)_________________________________________________________________       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |   http://www.iea-software.com

Previous message: Peter A. Sang: "DNS Management for Emerald?"
Next message: Dale E. Reed Jr.: "Re: Emerald would not issue a Renewal-Invoice"
Maybe in reply to: Josh Hillman: "SELECT DISCTINCT ability in Crystal Reports 5?"
Next in thread: Josh Hillman: "Re: SELECT DISCTINCT ability in Crystal Reports 5?"