Crystal Reports: An Easy Way to See the SQL Behind Your Report

• Crystal Reports: Generate SQL to Change Selected Records in Crystal Reports

• Crystal Reports: SQL Commands in Crystal Reports

• Crystal Reports: Useful SQL Utility: Crystal SQL Designer

• Crystal Reports: SQL Left Join

• Crystal Reports: SQL Commands for Creating Audit Records in Crystal Reports

• Crystal Reports: SQL Expressions and Sub Selects

If you have been using a SQL database but never really understood what SQL was or what it looked like, then here is an easy place to start.

If you have a report that uses an ODBC/SQL data source, look at "Show SQL query" in the database menu. This will display the SQL that Crystal Reports sends to the database server to retrieve records.

Look at the SQL each report creates and see the SQL the report writer generates. This is an easy way to learn this database language. You can make some changes here, but we don’t recommend it because changes to selection criteria in SQL override the Select Expert and Selection Formula, and we believe those are more flexible and powerful tools.

This article is copyrighted by Crystalkeen, Mindconnection, and Chelsea Technologies Ltd. It may be freely copied and distributed as long as the original copyright is displayed and no modifications are made to this material. Extracts are permitted. The names Crystal Reports and Seagate Info are trademarks owned by Business Objects.