Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Only want to show One record and not duplicates

Status
Not open for further replies.
Newbie69

Newbie69

IS-IT--Management
Joined
Mar 2, 2002
Messages
5
Location
US
I ahve a list of numerous ID's and I want to only show the first listing of that ID. But I still want to use the duplicates in calculations
 
Sort by date Sort by votes
One option is to Group by ID, place the fields of the
first record in the group header, and suppress the detail section.

Cheers,
- Ido ixm7@psu.edu
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

H
  • Locked
  • Question Question
Cannot get a sub-report to print without the headers and footers of the main report
Replies
1
Views
424
DjangMan
DjangMan
JustMe24
  • Locked
  • Question Question
How to select from 2 rows in a table
Replies
1
Views
719
SoftwareRT
SoftwareRT
David Richardson
  • Locked
  • Question Question
Adding BLOB Fields to Reports in Crystal Reports Professional 8.5
Replies
7
Views
1K
hilfy
hilfy
socalvelo
  • Locked
  • Question Question
Mouse Clicks not Working in Sections Area
Replies
2
Views
740
socalvelo
socalvelo
Corinne30
  • Locked
  • Question Question
Duplex Printing of Postcard reminders - Not printing back on last page.
Replies
1
Views
661
hilfy
hilfy

Part and Inventory Search

Sponsor

Back
Top