Sams Teach Yourself Crystal Reports® 9 in 24 Hours

Chapter 22. Optimizing SQL Queries in Crystal Reports

Earlier in this book, you learned about the new SQL Commands feature introduced with Crystal Reports 9. For those users not familiar with the SQL language, this hour will serve as an introduction and will help you get started with writing your own SQL Commands. For those users who are familiar with SQL (Structured Query Language), this hour will serve as a refresher with some important tips pertaining to the use of SQL with the new SQL Commands feature. This hour provides the following:

• A review of SQL Commands

• An introduction to the SQL Language

Review of SQL Commands

Hour 3, “Accessing Your Data,” introduced the new SQL Commands feature of Crystal Reports 9. Let's perform a quick review ...