How is a SQL Expression different than a Formula field?
There are many ways in which a SQL Expression differs from a Formula field: 1) The only functions available to a SQL Expression are database-specific functions as opposed to the common Crystal or Basic Syntax functions which are available in a Formula. The exact database functions available to you are determined by your database (SQL Server, Oracle, etc…) and your database driver (Native, CR-supplied ODBC and Third Party ODBC drivers). 2) The only fields available for use in a SQL Expression are true database table fields. You cannot incorporate Crystal functions, Parameters or Special Fields into a SQL Expression like you can in a Formula. 3) You cannot use Crystal or Basic Syntax (If-Then-Else statements, for example) in a SQL Expression. You can only use the database-native function syntax such as the Oracle Function ADD_MONTHS(D,N) which returns the Date (D) plus N months. 4) SQL Expressions are always handled on the database whereas Formulas are handled on the client. If you wer
