Can Oracle functions be used? 1

[tsusnik]

Is there any way to use Oracle functions in CrystalReports?

Thanks, Tomaz

 

[balves]

If you point a Crystal report at an Oracle stored procedure as the data source, then you can use whatever built-in functions are available in PL/SQL.

Other than that, probably not.

 

[rhinok]

If you use Crystal Reports 7 or above then you can build SQL Expressions. The database-specific functions are limited by your connection Driver (ODBC or Native). Keep in mind that SQL expressions can only be written against actual database fields, not Crystal Formulas, Parameters, etc...

SQL Expressions can be used within Crystal Formulas, Record Selection, etc.., however.