SQL Expression Fields

book list add book to my bookshelf create a bookmark purchase this book online

mastering crystal reports 9
Chapter 4 - Adding Business Logic with the Formula Workshop
Mastering Crystal Reports 9
by Cate McCoy and Gord Maric
Sybex 2003

Structured Query Language has its own set of functions and operators. You cannot pass Crystal Syntax or Basic Syntax functions to a database for processing. Any record selection formulas that reference Crystal Syntax or Basic Syntax formulas will be processed in Crystal and not in the database. Since a database is tuned for performance for large records sets, it is more advantageous to process data at the database level whenever possible. SQL expressions are one of the mechanisms you can use to pass processing off to the database. When a statement is coded completely using SQL, it can be passed directly to the database for processing and the resulting data set returned to Crystal Reports. Figure 4.41 shows the Function Tree and Operator Tree for SQL expressions.

click to expand
Figure 4.41. The Function Tree and Operator Tree for SQL expressions

Note 

The Formula Expert cannot be used to create SQL expression fields.

Use of content on this site is expressly subject to the restrictions set forth in the Membership Agreement
 
Conello © 2000-2003     Feedback


Mastering Crystal Reports 9
Mastering Crystal Reports 9
ISBN: 0782141730
EAN: 2147483647
Year: 2005
Pages: 217

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net