joesmithf1
Registered User.
- Local time
- Today, 09:15
- Joined
- Oct 5, 2006
- Messages
- 56
Hi All,
I am fairly new to Crystal, so still trying to learn. i am creating a report where i am able to get some good results, but now i am getting duplicates. Please see sample results:
0000018573 15 01 12/31/9999 1415 01FNR GARY JAMES
0000018573 15 01 12/31/9999 1415 01FNA GARY JAMES
0000018573 15 01 12/31/9999 1415 01FBE GARY JAMES
Notice there are 3 records for James. This is b/c he has 01FNR, 01FNA, and 01FBE. My question is, how to i display only the top record in the report? I tried Group Expert on ID(0000018573) then Section Expert and 'hide' Drill Down, but that only give me his ID(0000018573) on the report; i 15,01,12/31/999, 1415, and GARY JAMES on the report as well.
Thankyou.
Joe
I am fairly new to Crystal, so still trying to learn. i am creating a report where i am able to get some good results, but now i am getting duplicates. Please see sample results:
0000018573 15 01 12/31/9999 1415 01FNR GARY JAMES
0000018573 15 01 12/31/9999 1415 01FNA GARY JAMES
0000018573 15 01 12/31/9999 1415 01FBE GARY JAMES
Notice there are 3 records for James. This is b/c he has 01FNR, 01FNA, and 01FBE. My question is, how to i display only the top record in the report? I tried Group Expert on ID(0000018573) then Section Expert and 'hide' Drill Down, but that only give me his ID(0000018573) on the report; i 15,01,12/31/999, 1415, and GARY JAMES on the report as well.
Thankyou.
Joe