PDA

Click to See Complete Forum and Search --> : distinct

EyeTalion
Aug 28th, 2006, 10:53 AM
Is it possible to manually change the SQL query generated by Crystal? I'm looking to add the DISTINCT function to the query...
brucevde
Aug 28th, 2006, 11:58 AM
To use Distinct, there is a menu option

Database -> Select Distinct Records

FYI: You cannot manually change the Selection List of the query but you can modify the Where clause.

Database -> Show SQL Query