Is it possible to manually change the SQL query generated by Crystal? I'm looking to add the DISTINCT function to the query...
Printable View
Is it possible to manually change the SQL query generated by Crystal? I'm looking to add the DISTINCT function to the query...
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