Crystal Reports Online Training

Learn Online, Anytime, Anywhere

Step-by-step tutorials and online videos.

Click Here To Learn More »

11.03 Optimizing Record Selection

Optimizing Record Selection

The WHERE clause of the SQL query specifies how records are filtered. It lists the fields to be filtered on and the criteria for specifying which records to select. This is what you do when using the Record Selection dialog box to specify which records you want displayed on the report.

When Crystal Reports builds the SQL query to pass to the database server, it looks at the record selection formula and tries to convert it to its SQL equivalent. When it is successful with the conversion, the database filters the records at the server prior to passing the result set back to Crystal Reports. This results in a significant performance improvement.

When the record selection formula can’t be converted to a valid WHERE clause, it won’t be included in the SQL query passed to the database server. Only the SELECT portion of the SQL statement is sent. This results in the database server passing all the records from the SELECT statement back to the client computer. More traffic is put on the network and Crystal Reports has to manually process all the records using the selection formula. The result is a much slower performance than what would have...

Get UNLIMITED Crystal Reports Online Training!

Click Here To Start Your Training!

1500+ Tutorial Pages

Complete Crystal Reports Online Training with over 1,500 pages of better than book quality Crystal Reports tutorials.

Step-by-step Online Videos

Learn at your own pace from the comfort of your home! Pause, rewind and watch online training videos anytime!

Online Community

Members-only community where you can post and answer questions. The community is checked on a regular basis by best selling Crystal Reports book author Brian Bischof to help answer your questions.

Cut & Paste Source Code

Save time with simple cut and paste source code you can use right now in your next report!

Click Here To Start Your Training!