duplicates

[emuye]

Venodor name address city st zip phone
b676 brown 2829 park maple mn 55404 748-2411
b676 brown 2829 park maple mn 55404 748-2411
m110 jim O mail stop 11 mankato mn 56001 345-3845
p320 fan mail stop 12 st.paul mn 55155 654-2351
p320 fan mail stop 12 st.paul mn 55155 654-2351

I have a view table that i have created on oracle 9i database in order to produce this report.however,for some reason i am getting a duplicate record as you see above.i did try to select a distinct recod by checking distinct record and i also have a distinct clause in my view table.if some one has any idea how i can eliminate this duplicate fields please help me out.

 

[synapsevampire]

A View isn't a table.

Check the data more closely, you'll find that one of the fields selected in the Database->SHOW SQL QUERY differs.

Try posting:

Crystal version
Database/connectivity used
Example data
Expected output

Since you've not posted anything about the tables, relationships, the View SQL, nor anything technical, I'll just suggest that you group by whatever fields make it unique (all of the above, just the vendor, or ???), and place the fields into the Group footer instead of the Details for display purposes.

-k