SQL Expression Fields

[Former Member]

In crystal report 2008,I create a SQL Expression Fields，but how to write the SQL query in the formula workshop,

Edited by: nylethx1 ye on Jul 23, 2008 9:48 AM

[fritzfeltus · Accepted solution]

You can also use DB specific functions on their own; this is an example SQL expression formula for MS Access:

{fn UCASE(`Customer`.`City`)}

The SQL Expression will be added to the report's SQL statement, so keep this is mind when creating your formula.

Edited by: Fritz Feltus on Jul 23, 2008 10:23 AM

[Former Member]

i receiving error on sql expression field.i am using ms access..

but i receive a message

error in compiling sql expression

failed to retrieve data from database

ado error code 0x80040e14.........

.......

native error  ..... how to clear tha??????

[DellSC]

Your first step is to Google the error code, which is specific to the database.  Because Access is not a client/server database you may not be able to use SQL Expressions with it - I could be wrong though as I do not really work with Access.  Also, you cannot use any Crystal functions in a SQL Expression - everything you do needs to be in the same syntax that Access uses for SQL.

-Dell

[Former Member]

(
Select count(*) from Table
)

Your query must return a unique value.

From Don: SQL Expressions were not designed to run SELECT statements. Use a Command object for selects.

Edited by: Don Williams on Nov 2, 2009 9:29 AM