A few basic Crystal Report VB questions

[(Slith++)]

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)?

[brucevde]

Both. When it can, Crystal will add fields to the Where clause for server processing. Otherwise it will first get the records and then apply any filters and/or formulas that you have specified.

Crystal will create the Order By clause the same way. If you have complex formulas for sorting, data is first retrieved and then sorted on the client.

Crystal may make several passes through the data before it finally gets viewed. It depends on the complexity of the report.

[(Slith++)]

Thanks Bruce.

So I guess what your saying if it can do it server side it will. If it cant it will do it client side.

[brucevde]

Exactly.