Return one of many

[lawre016]

I have 2 SQL tables linked by the document number. The first table has multiple entries for each document, the second table has only one entry. I need to only show the first record from table one, not each entry. The results currently look like this:

14-1-001355 02 RETAINER
14-1-001355 02 RETAINER
14-1-001355 02 RETAINER

I just need to show the first line.

Any help would be greatly appreciated! Thanks.

 

[kenhamady]

There is a big diffrence between 'returning' one of many and 'showing' one of many since CR won't know which is first until all are returned.

If you want to just 'show' the first you should group by document, and sort so the first record is always first in the group. Then you move your fields to the Group Header and suppress the detail section. Grand totals will include the suppressed records. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[lawre016]

Thank you. That worked great.