Eliminating the second phone number

[akar33]

Hello,
I ahve data set that appears in the report is as follows

ID# Name Address Phone# Instructer Room#
1234 Tina 123 wweee 987-0987 NN 102
1234 Tina 123 wweee 098-0987 NN 102
0976 Mom 3636 hhhh 098-9876 OO 102


The output desired ist and the third data set not the second one.

Thanks
Annie

 

[rosemaryl]

Dear Annie,

Group on ID# ... Place all data you want to report in the group header for ID, suppress details. Suppress footer.

regards,

ro

Rosemary Lieberman
rosemary-at-microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

You will get answers more quickly if you read this before posting: faq149-3762