Ok I have Crystal Reports for Visual Studio .NET 2003.

I have created a blank report and added my fields from the database.

When I go to Right click Database Fields > Show SQL Query it shows me the query its using to get the data from that database.

Is there any way to edit this?

I mean, I would like to add a WHERE clause and ORDER BY clause.

Though I do know I can filter out results using the 'Select Expert'. Does the 'Select Expert' do the filtering on the SQL server side or does it get all the records and do the filter on the client (computer where app is running)?