DISTINCT

[eoceguera]

how can i use the DISTINCT select clause with crystal reports.. I want the SQL query that crystal does..to use the DISTINCT clause..

for example.. i need the SQL query to be

select distinct (field1),field2,field3
from table
where condition..

i don't have a problem creating the report that produces a query without the DISTINCT clause.. i just need to be able to ad it.. any suggestions???

thank you very much.. i'll appreciate any answer

 

[MalcolmW]

for v8
Database|Select Distinct Records

for v7 and below, but not for the faint of heart

http://support.seagatesoftware.com/library/kbase/articles/c2007732.asp

Malcolm